RE: [PHP-DB] news manager
| From: | Matt Braynard | Date: | Wed, 28 Mar 2001 18:19:16 +0000 |
| Subject: | RE: [PHP-DB] news manager | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-8007@lists.php.net to get a copy of this message | ||
Yes -
Use the current date generated by php date functions in place of where you
would hardcode today's date.
Matt
-----Original Message-----
From: Mike Baerwolf [mailto:mike@wkla.com]
Sent: Thursday, March 29, 2001 2:21 PM
To: php-db@lists.php.net
Subject: [PHP-DB] news manager
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