accidentally replied only to karen.

> 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,

> $today = getdate();
> $month = $today['month'] ;
> $mday = $today['mday'] -1;
> $year = $today['year'];
> echo "Data is current  as of  <b>$month $mday, $year</b><br>";
you can do the same thing with php.

I'd use a timestamp and subtract 86400 (24 hours of seconds)

$yesterday_at_this_time = date("Y-m-d H:i:s", time() - 86400);

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

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to