Date problem
| From: | Denis L. Menezes | Date: | Sun, 21 Jan 2007 16:26:35 +0000 |
| Subject: | Date problem | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-42963@lists.php.net to get a copy of this message | ||
Dear friends.
I have a date field in mysql called event_end .
I want to run a query to find all records where the event_and is greater
than today's date. I have written the following code. It does not work.
Please point out the mistake.
$today = getdate();
$sql="select * from events where event_end>'.$today.' order by event_start
Asc ";
Thanks
denis