hi
How can create a mysql query using php that compare if a value in a date column (yyyy-mm-dd) is not greater than the current date ?
Select * from table Where thedate > (NOW())????
Select * from table Where thedate > (CUR_DATE()) ???
thank´s in advance
you're question and your examples conflict. you want to select all records where the date is BEFORE today, right? if so:
SELECT * FROM table WHERE date < CURDATE()
if you want to select future dates:
SELECT * FROM table WHERE date > CURDATE()
Do i have to use date format or anything else in my date field?
the examples did not work i try t use (CUR_DATE())
what is your exact data structure (table name, field names, field types, etc...)
table : meetings column: meeting_date column type : date
SELECT * FROM meetings WHERE meeting_date < CURDATE()
Thank´s a lot best regards
