Nieuw lid |
|
die had ik ervoor al geprobeerd, maar blijkt niet te werken om één of andere reden.
$query="SELECT * FROM agenda
WHERE datum='DATE_SUB(CURDATE(),INTERVAL 30 DAY)'
GROUP BY datum,opdracht,vak,opgave,opdracht
";
$query="SELECT * FROM agenda WHERE datum='DATE_SUB(CURDATE(),INTERVAL 30 DAY)' GROUP BY datum,opdracht,vak,opgave,opdracht ";
FOUT: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '
WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY) GROUP BY datum,opd' at line 1
FOUT : You have an error in your SQL syntax ; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE DATE_SUB(CURDATE(),INTERVAL 30 DAY) GROUP BY datum,opd' at line 1
|