MySQL Query

Jadnet

I need to call a date from a table and then i want it to display the list but no dates from the present will be shown only today's and future dates should be in the list

Jadnet

Boosting to the top me needs a reply

goa103

hi,

Boosting to the top me needs a reply

well I advice you to change your subject. MySQL query doesn't mean anything special to us. explain the help you need, see ?

anyway for your date pb, you should compare the date field with the current date, you can use the comparison operator for that. if the date is < to the current one, past, otherwise, future.

so something like:
"SELECT * FROM mytable WHERE mydate>='$curdate'"
should work.

note: DON'T FORGET the single quote (') between >= and " because a mysql date is YYYY-MM-DD HH:MM:SS!