I am now building a script to build reports on users queries from a html form. They have the option to select a date range.
My code in the script to build the query is this:
Code: Select all
$sql = mysql_query("SELECT * FROM foo WHERE date BETWEEN '$startdate' AND '$enddate' ORDER BY date"); This can't be to difficult, but I can't seem to find out where I've gone wrong.
Any suggestions?