Code: Select all
$today= date("Y-m-d");
$cityID = $_GET["cityID"];
$sql = "SELECT * FROM event WHERE Event_Date <=".$today." AND Event_CID=".$cityID." ORDER BY Event_Date ASC LIMIT 20";when using the greater than sign, like above, i get dates from both sides of the date
when using the less than sign, i get no dates displaying at all.
any ideas of what i could do?
thank you!