[PHP-DB] news manager

[Mike Baerwolf]

Hello,

I'm working on a news manager and would like to display records for 
today,yesterday,last week, last month and so on.  This is what I have so far,

$result = mysql_query("SELECT * FROM news WHERE timestamp=010325",$db);

    if ($myrow = mysql_fetch_array($result)) {

Is there a way to do this without having to change the timestamp=value everyday?

Thanks for the Help,
Mike