Date problem

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

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Date problem

At 12:26 PM 1/21/2007, Denis L. Menezes wrote:

>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

How is your date formatted in the database.

Compare that to the format returned by getdate(), then consider using
date('Y-m-d'). That's assuming your MySQL date is stored as yyyy-mm-dd.

Nonetheless, this should set you on the right road.

It would also have helped your diagnosis if you echoed your SQL statement.

Cheers - Miles Thompson




--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.410 / Virus Database: 268.17.3/642 - Release Date: 1/20/2007

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php