news manager
| From: | Mike Baerwolf | Date: | Thu, 29 Mar 2001 19:21:26 +0000 |
| Subject: | news manager | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-8006@lists.php.net to get a copy of this message | ||
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