Hi Can anyone please help?
I want to search between two dates from a date opened I have the following code but sadly is not working
$sql = "SELECT * FROM Log WHERE Date_Opened = '" BETWEEN '" & Date_1 & "' AND '" & Date_2 & "'" ORDER BY DateOpened DESC ";
if (empty($_GET['Date_Opened']))
$sql = "SELECT * FROM Date_opened WHERE 1 = 2 ";
$res = mysql_query($sql);
<form>
Start Date:<input name="Date_1" type="Date" value="<%=Date_1%>" size="15" />
End Date:<input name="Date_2" type="Date" value="<%=Date_2%>" size="15" />
<input name="Submit" type="submit" />
</form>