Here is the code that I used and found not working.

$t=time();
$t-=84600;
$q="select * from flash where time>=".$t." order by time desc limit 10";
$result=mysql_query($q);

whts wrong with it???

The query returns all the rows in the table irrespective of the constraint.