more probs

[Mr. 47]

$mysql_date = date(Y-m-d);


select * from mncc_events where event_mysql_date >= $mysql_date order by event_mysql_date asc, event_id desc limit 0,10


what is wrong with this query???

it works fine if i replace $mysql_date with 2003-03-20...

 

[[UKLans]Khan]

I'm a real PHP newb but try this

= date("y.m.d");

Khan

 

[[UKLans]Khan]

Actually I don't think that will help, sorry.

I just read here:

http://www.php.net/manual/en/function.date.php

Khan

 

[Mr. 47]

Originally posted by [UKLans]Khan
I'm a real PHP newb but try this

= date("y.m.d");

Khan

No, that won't help it needs to be YYYY-MM-DD for MySQL and not YYYY.MM.DD

 

[[UKLans]Khan]

Actually I don't think that will help, sorry.