After many frustrating hours I'm still having a problem. I have tried multiple ways of writing the SQL query line but it still is not correct. I am using this code
PHP Code:
$time = mktime(date('H'), date('i'), date('s'), date("m"), date('d')-2, date('Y'));
$urls = mysql_query("SELECT linkid,linkurl FROM adv_links WHERE dateline > '". date('Y-m-d H:i:s', $time) . "' ORDER by linkid ASC");
But my query is still returning all results from the beginning, not just the last two days. The query does sort by the correct order though. Any help would again be appreciated.
Thanks,