Querying between dates via a web app.

[Nico]

I'm quite new to the php/mysql area but I like it I can do basic tables in mysql and queries via php. I'm trying to move on and need some assistance. I'm trying to write a query in php to get a date range from the mysql table. The user will input two dates via a webpage to search the database. (i.e. I input 07/10/2002 and 08/10/2002 to serach for all records created on and between those dates) I have tried a few different ways to do this, however none have been successful. Please help me out! Your help is VERY much appreciated!


Nico
8O

[fresiafunk]

You try Select * from table where date BETWEEN 'date1' AND 'date2' ??? :roll:

[Nico]

Its certainly quite possible that i'm writing the php stuff incorrectly tho... I made the text fields date1 and date2 so I use BETWEEN '$date1' AND '$date2'

I know that typing that into the command line works, but i can't get it from webpage to query back to webpage.

Sorry I should have been more specific-- I know the BETWEEN works, but my php is quite poor

Nico

[Nico]

<cough cough> syntax

[Jay]

Make sure you're querying the date in the same format as you're storing them!