Problem with date syntax

[scialom]

Hi

I have this sql:
SELECT tbl_article.title, tbl_document.doc_date, tbl_document.doc_id, tbl_document.type FROM tbl_document, tbl_article WHERE tbl_document.doc_id=tbl_article.doc_id and tbl_document.lang=0 and tbl_document.type=3
and tbl_document.doc_date>2001/01/01 and tbl_document.doc_date<2002/01/01 ORDER BY tbl_document.doc_id LIMIT 0, 30

when I run it in mysql server it is ok, but when I put it in php I get error message. Why?

Assaf

[PHPdev]

What is the error message you are getting? Also you may try putting ' around your dates...

PHPdev

[scialom]

hi

this is what I get when I put '
Error performing query: You have an error in your SQL

Error performing query: You have an error in your SQL syntax near 'tbl_document.doc_date>'2001/01/01' and tbl_document.doc_date<'2002/01/01' ORDER ' at line 1

If I dont put the '
I get this error:
line 1

Error performing query: You have an error in your SQL syntax near 'tbl_document.doc_date>2001/01/01 and tbl_document.doc_date<2002/01/01 ORDER BY t' at
have an error in your SQL

It is working in mysql server...

Thanks,
Assaf

[PHPdev]

Generall "near" means in front of. Two things come to mind... try putitng a space between the table.field and the dates like

table.date > '2002/10/02'

and you can also do this... just before you execute your query do a

die($query);
mysql_query($query) or die(mysql_error());

Where $query is storing the whole sql query, thus pringing the exact syntacx out to the screen... look for proper spacing etc...

If you still can not find anything copy and past it into a MySQL> see if it runs there, or paste it here and Ill take another look

THanks

PHPdev

[scialom]

thanks.

The spaces help!

Assaf