php & mysql - query on a range

robsgaming

I need help with a query I'm trying to run but have no idea how to. I have a table called 'orders' in which orders are stored that are received from the net on my site...

In the table, there is a OrderDate column. How can I run a query that will select a certain range of dates say from 8/1/2002 to 10/1/2002 ?

Any help is appreciated.

Thanks again,

Rob H

_SuperString

try this:

sql = "SELECT * FROM orders WHERE OrderDate BETWEEN '8/1/2002' AND '10/1/2002'";

robsgaming

Just noticed something. I forgot in my table in the order date it puts in information like this:

7/28/2002 5:32:10 PM

With date AND time

Therefore, the query you gave me did not work.

I tried:

sql = "SELECT * FROM orders WHERE OrderDate BETWEEN '8/1/2002%' AND '10/1/2002%'";

it did not work either.

Thanks for the reply.

_SuperString

What is the datatype of the OrderDate field ? if it's a timestamp/date/dattime then you could use 'yyyy:mm:dd' format.

robsgaming

its 'datetime' type

i cannot change the contents of it as its something im trying to modify for a company i work for. it needs to stay the same.

_SuperString

did you try it this way ?

sql = "SELECT * FROM orders WHERE OrderDate BETWEEN '2002:10:01' AND '2002:10:10'";

I think it is stored in MySQL with this format (yyyy:mm:dd hh:mm:ss) so the above should work.

robsgaming

Yes just tired it but had the data mixed up. It is working now. Thanks greatly for your help... much appreicated.

Best Regards,

Rob H