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:[EMAIL PROTECTED]]
Sent: Thursday, March 29, 2001 2:21 PM
To: [EMAIL PROTECTED]
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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]