QUERY OK , 0 ROW AFFECTED ???

[cabernet]

Hello,
I cannot get that little piece of syntax working
"DELETE FROM articles where adate BETWEEN '02/25/2003' AND '02/27/2003' AND sectionID =4;"

all elements are corrects and existing, I do not have an access problem since I own the Apache server and the DB

Out of curiosity I also tried to precise a date without "BETWEEN, but always get:
"Query OK, 0 rows affected"

Thank you

 

[swampBoogie]

Your dates aren't recognized by Mysql

DELETE FROM articles
where adate BETWEEN '2003-02-25' AND '2003-02-27'
AND sectionID = 4

 

[cabernet]

ooops, wrong format - Now it works -
thank you very much