SQL Query based on last 48 hours?

[Marco van Herwaarden]

Lol, mistake (in all these examples!!) you get by editing code and not read good what the result is.

The following is valid:

PHP Code:

$urls = mysql_query("SELECT linkid,linkurl FROM adv_links WHERE dateline > " . (time() - (2 * 24 * 60 * 60)) . " ORDER by linkid ASC"); 


- ORDER must be after the WHERE clause (can't believe everyone, including myself, made this same mistake)
- TIMENOW is only defined within a vBulletin environment, so replace by time()