SELECT time trouble

[planetsim]

Ive got a News Headlines Script. Which is still needing some tweaking.

Im trying to make it so that the Headlines are pulled out only for the last week..

$result = $db_class->query("SELECT * FROM news WHERE time < '".(time()-604800)."' ORDER BY time DESC LIMIT 5");

As im using INT(11) as the time feild im having trouble getting the headlines in the last week...

[barand]

I think you made a couple bad choices there

1. calling the field 'time' (reserved)

2. Not making it a datetime field with a host of functions for just this event
   [/list=1]

   You can get round the first by using time in the query.

   As for the second, if the above hasn't cured it, you may be able to cast it with UNIXTIMESTAMP(time)

   hth