BETWEEN date query

[e1seix]

Guys, the code is pretty self-explanatory - I just can't get it to work. Have numerous entries in mysql database with "from" and "until" dates covering the course of a year. I'm trying to ascertain the correct code to select the relevant row that today's date falls between.

 

Can you help?

 

$query = 'SELECT * FROM shop WHERE from <= "'.date("Y-m-d").'" AND until >= "'.date("Y-m-d").'"';

 

Always appreciated.

[jskywalker]

it would have been simpler if you had googled for the error message the system gave you

 

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'from <= "2010-05-15"' at line 1

 

'from' is a reserver word (http://dev.mysql.com/doc/refman/5.1/en/reserved-words.html)

 

change your query to use backquotes.

 

SELECT * FROM shop WHERE `from`..... AND `until` .....;