[Resolved] mysql WHERE help please.

[bike5]

How would I write the code to do

$Querym = "SELECT * FROM $TableName_n WHERE ("time()-"news_time) < 604800 && news_show = 1";

I am trying to retreive any news posted in the last 7 days and also make sure the news_show == 1. I tried serval way of setting it up but couldn't seem to get it right. Any help would be great, thanks a lot.

[LordShryku]

Are you generating the timestamp with PHP when you insert it? Or is this a MySQL timestamp?

[bike5]

I used date("U") for the timestamp in the database.

[LordShryku]

Ok, so just generate the timestamp from seven days ago, and look for greater than.

$end = strtotime("-7 days");
$sql = "SELECT * 
          FROM ".$TableName_n."
         WHERE news_time > ".$end."
           AND news_show = 1";

[bike5]

Ok, I didn't know I could generate it like that, thanks for the help.