I had no problems with retrieving news stories from previous days before
2002, and haven't changed any of my code.  This site has been up for a year,
and I can't recall anything like this happening when 2001 rolled around.

Please excuse the messy code, as this was the first php/db web site I
designed. I took out the formatting stuff...  :)

>From my php page, I call a function:

get_most_recent_stories(date("Ymd"));
- which passes today's date, formatted for for the db

In my code:

 - this is the function I call - which in turn calls the function below
(no_yesterdays_stories($datetoget) to subtract a day if there is no news
items for the current date, which then calls the same
get_most_recent_stories() function, but passes a "lower" date. Ideally,
these will loop until there are stories found for a certain day.


function get_most_recent_stories($datetoget)

{
//Get the headlines, summaries and links to the story
db_connect();
$sql = "SELECT * FROM tblStory WHERE (StoryDate=$datetoget)";
$results = mysql_query($sql);
    if ($results) {
        if ($row = mysql_fetch_array($results)) {
            echo $row[StorySum];}
            while ($row = mysql_fetch_array($results));
            } 
        else {
            no_yesterdays_stories($datetoget); } }
} 

function no_yesterdays_stories($datetoget)

{
//query has returned no stories from yesterday (holiday, etc.)
//keep subtracting on day from yesterday's date until there are stories
found
$datetoget=($datetoget-1);
get_most_recent_stories($datetoget);
}

-- 
Faye Keesic
Computer Programmer Analyst/Web Page Design


> From: Rick Emery <[EMAIL PROTECTED]>
> Date: Wed, 2 Jan 2002 09:05:42 -0600
> To: [EMAIL PROTECTED]
> Subject: RE: [PHP-DB] Date problem with new year
> 
> No bug, mate.
> 
> Post your code so that we can help ya...
> 
> -----Original Message-----
> From: Faye Keesic [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, January 02, 2002 8:56 AM
> To: [EMAIL PROTECTED]
> Subject: [PHP-DB] Date problem with new year
> 
> 
> I have a db site that always displays the most recent occurrence of news
> stories....
> 
> The last occurrence of stories was last year (2001-12-31) and up to the new
> year rolling over, I had no difficulty subtracting days, etc.
> 
> Is there a bug in Mysql?  PHP that I don't know of..
> 
> Please help.
> 
> 
> -- 
> 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]
> 
> -- 
> 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]


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

Reply via email to