$datef = (date("Y-m-d",mktime(0, 0, 0, $_GET['year'], $_GET['month'], $_GET['day']))); $datel = (date("Y-m-d",mktime(0, 0, 0, $_GET['year1'], $_GET['month1'], $_GET['day1']))); echo $datef.$datel; $result = mysql_query("SELECT f8_0, n7_91, t_stamp FROM westdrayton WHERE t_stamp BETWEEN '".$datef."' AND '".$datel."' limit 20");
I have this PHP code to try and grab records from between the two dates in a mysql db. In the database i'm just timestamping every record that comes in.
Any one spot why this code wouldnt work?