I have got a field in a mysql table with datatype date.  I can call it up and print it out - it comes out in the format 2002-10-1.  However I cannot get a comparison to work in an sql statement eg

select * from erfn where LesDiv = 1 and PublishDate > '2002-10-1'

gives the error message
Warning: Supplied argument is not a valid MySQL result resource

I am using it in a php page.

I have tried other formats like '10/1/2002'

Any suggestions?

TIA


Have you tried "01" rather than "1" for the day?  This may seem the ultipmate of picky-ness, but all the format descriptiors do talk about DD rather than just D.

I do also question whether the error is generated by your select statement at all, or if it's caused by a variable name being mis-spelled;  this is the sort of
error message I would expect if I wrote
Code:

$resultxxx = mysql_query($query,$dbid); while ($row = mysql_fetch_row($resultxxy))  {

Sorry not to reply sooner - it was indeed a mistyped variable name.  Thanks.

---