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 ";


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 (
To unsubscribe, visit:

Reply via email to