PHP mySQL Select query by date
Posted on 2008-11-03
I'm trying to use the following code to select data by a date range and display it. I can display it fine, but I can't seem to get the mySQL query right...
$url; is an exploded query_string. The value is 11/01/08
$searchval = $url;
$itemsbydate = mysql_query("SELECT id,group_number,group_name,date_received,disposition,DATE_FORMAT(date_received,'%Y%m%d') as recdate from inquiries where userid='$userid' and recdate=$searchval");
while($disprow = mysql_fetch_array($itemsbydate, MYSQL_ASSOC))