MySQL - Date

[Anon]

Hi, I need some help...

I have an input field with the name "date_on", where I want for input to be like:
MM/DD/YYYY
Then, my SQL statement should check if the date in $date_on >= today's date.

What's the "Today's date" in MySQL? :
date() or now() ?

For example:
select * from stuff where '$date_on' >= now() order by id asc;

Please help...

[Anon]

You're going to have problems with this. MySQL stores it's dates in YYYY-MM-DD format so you will have to convert one or the other in your statement.

CURDATE() is the MySQL function that you are looking for.

[Anon]

Thanks buddy