between dates

[acidglitter]

I have a query like this:

 

mysql_query("SELECT * FROM orders
WHERE date_purchased BETWEEN $start_date AND $end_date
ORDER BY orders_id ASC");

 

$start_date and $end date are from an html form.. they're just in date format (like 2008-03-24). It seems like that query should work but its not. I looked and date_purchased is a datetime type. Is that why this isn't working? And if it is how can I get this to work?

[Daniel0]

What are the expected and actual results?

[Barand]

date strings need to be in quotes

<?php
mysql_query("SELECT * FROM orders
WHERE date_purchased BETWEEN '$start_date' AND '$end_date'
ORDER BY orders_id ASC");

Try using mysql_error() to report problems to you

[acidglitter]

date strings need to be in quotes

<?php
mysql_query("SELECT * FROM orders
WHERE date_purchased BETWEEN '$start_date' AND '$end_date'
ORDER BY orders_id ASC");

Try using mysql_error() to report problems to you

 

wow i can't believe i forgot that lol. well its working now that it has the quotes.. thanks for the replies