yesterday's date problem...

Anon

Hello!

I'm currently learning how to write PHP script for displaying On Day Like Today events.

Everything works fine except when we are first of the month the usage of:

$eday = $today[mday]-1;

is simply not useful. Does anybody have any idea how to avoid this problem. I need to display the events for today, yesterday and tomorrow date.

Here is the portion of the script that displays yesterday’s events:

<?php

include("config.php");

mysql_connect($dbhost, $dbuname, $dbpass);
@mysql_select_db("$dbname") or die ("Unable to select database");

$today = getdate();
$eday = $today[mday]-1;
$emonth = $today[mon];

$result = mysql_query("select yid, dogodki from $prefix"._ephem." where did='$eday' AND mid='$emonth'");

while(list($yid, $content) = mysql_fetch_array($result)) {

if ($cnt==1) {
echo "<br>";
}
echo "<b>$yid</b></b> - $content";

    $cnt = 1;
}

Thnx, Dean.

[deleted]

Lesson one in dealing with dates is: don't deal with dates.

Instead, work only with timestamps. A timestamp is a time expressed in seconds since 01-01-1970 (there are different type, but this is pretty much the standard)

Using a timestamp means you can go back or forward to any date by subtracting or adding the number of seconds equal to the timespan you want to subtract or add.

For example: going back on hours means subtracting 60 seconds.

From that timestamp you can then re-create the date using PHP's date() function.

required reading:
http://www.php.net/manual/en/function.mktime.php
http://www.php.net/manual/en/function.strftime.php
http://www.mysql.com/doc/D/a/Date_and_time_functions.html

Anon

vincent wrote:

For example: going back on hours means subtracting 60 seconds.

ummm... 1 hour=60 seconds?

:-)

[deleted]

It was late (in my timezone) I was overworked, the lights were red, the bridge was closed, I had a flat tire, I don't get paid enough, I have a headache, it's monday, it's tuesday, it's wednesday, it's thursday, it's friday, it's saturday, it's sunday, it's 2001....

Anon

for a minute there, I thought you were quoting Belushi from the Blues Bros. :-D