Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2004071

[PHP-DB] Date problem: data is current as of yesterday From: Karen Resplendo (karenresplendo <email protected>)
Date: 07/02/04

The database queries all the sources at night after everyone has gone home. That means the data was current as of yesterday. This little snippet below returns yesterday's date, except that the first day of the month returns "0" for the day. Now, I know why this is happening, but I can't find out how to fix it (in VBA or SQL Server I would just say, "date()-1":
 
$today = getdate();
$month = $today['month'] ;
$mday = $today['mday'] -1;
$year = $today['year'];
echo "Data is current as of <b>$month $mday, $year</b><br>";
 
 

                
---------------------------------
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!