how do i display all database entries between two dates

[jbrill]

I have two dates in a form " startdate" and enddate"

 

when i display the results i would like to show all results between, and including the two dates. how do i do this... this is my current query:

 

My Variables:

 

$userid = $_GET['idr'];

$fromdate = $_GET['fromdate'];

$todate = $_GET['todate'];

 

The query:

 

$result = mysql_query("SELECT date, status, time, notes FROM timeclock WHERE userid='".$userid."' ORDER  BY time");

 

 

[jbrill]

anyone?

[JasonLewis]

my mysql querying isnt the greatest but try this:

 

$result = mysql_query("SELECT date, status, time, notes FROM timeclock WHERE userid='".$userid."' AND date BETWEEN {$fromdate} AND {$todate} ORDER  BY time");

 

but your date formats have to be the same, i think. hope that helps.