select a date range

[searls03]

hello all, I have been working on a calendar system for someone, and they were using one date events....now they want events with a range.  I have this code working to select one date 

 

$result = mysql_query("SELECT * FROM classes where date='".$m1."/".sprintf ("%02u", $d)."/".$year."'");....this is fine, don't critique it please.

 

 

My data base now has a start date and an end date fields in them.  I need to know how I can pull the data if the date that I want to display falls inbetween or on those startdate and enddate field.  

 

so for example, May 1st through the 5th is an event called test

 

i would like it to pull data and then display it similar to this:

 

1-test

2-test

3-test

4-test

5-test

 

 

the numbers being the May "date".  can anyone help me with this?

[Jessica]

Use BETWEEN. Moving this to the MySQL forum.

[requinix]

That "date" column is an actual DATE-type column, right?

[searls03]

Actually that fate won't be there anymore, the "date" for reference will be created via php.

[Barand]

So you are trying to search by date on a database table that has no date field?