Tosmomiaccils
New Member
I need a query to select data between two dates with today's date as a reference.The database has a datetime field for "start" and a datetime field for "end".\[code\]$todays_date = date("Y-m-d H:i:s");$q = "SELECT * FROM news WHERE `end` >= '" . $todays_date . "' AND `start` >= '" . $todays_date . "' ORDER BY id DESC";\[/code\]The problem is the query is still pulling results where the start date is greater than today. So then i modified my query to look like this:\[code\] $q = "SELECT * FROM news WHERE `end` >= '" . $todays_date . "' AND `start` >= '" . $todays_date . "' AND `start` <='" . $todays_date . "' ORDER BY id DESC";\[/code\]Is this the correct way of selection data between two datetime fields that uses todays date as a limiter?Thanks