[philmckrackon]

Good day, I have a very simple mysql query that I would like to be based on time. I only want results for the query based on data from the prior 48 hours. After changing the query to what I believe is correct (with the help of others) I can never get passed a mysql fetch error. Any help would be aprreciated as I am stumped on this (so I thought) easy code.

Original SQL query that functions -

PHP Code:

$urls = mysql_query("SELECT linkid,linkurl FROM adv_links ORDER by linkid ASC"); 

One of the many different new queries I have tried (dateline is the field with the date I need to reference)-

PHP Code:

$urls = mysql_query("SELECT linkid,linkurl FROM adv_links ORDER by linkid ASC WHERE unix_timestamp() - dateline <= 3600*48"); 

And another query that does not work -

PHP Code:

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

The fetch line that always errors out (with the remainder of the code)-

PHP Code:

while ($urlrow = mysql_fetch_array($urls)) {

fwrite($file," ");

fwrite($file, $urlrow[1]);

fwrite($file, " | "); 

fwrite($file," ");

fwrite($file, $urlrow[0]);

fwrite($file," \n");

}

fclose($file); 

?> 

And the error -

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/****/public_html/pagevisD.php on line 13

Thanks again,

[Jay6390]

SELECT `linkid`,`linkurl` FROM `adv_links` WHERE UNIX_TIMESTAMP() - UNIX_TIMESTAMP(`dateline`) < 172800 

That should do it