Sorry for the delay... include --enable-calendar in the php compilation.
On Wed, 2 Jan 2002, Faye Keesic wrote:
> Okay, when I try to change the gregorian date to julian, I get
> error: call to undefined function: gregoriantojd() in line...
>
> Here's the code I used to replace $datetoget=($datetoget-1);
>
> //from what I understand ,must be in month, day, year format
> //so passed today's date
> $greg_date=GregorianToJD(1,2,2002);
> //subtracted a day
> $greg_date=($greg_date-1);
> //converted it back to gregorian format
> $datetoget=JDToGregorian($greg_date);
> --
> Faye Keesic
> Computer Programmer Analyst/Web Page Design
>
>
> > From: [EMAIL PROTECTED]
> > Date: Wed, 2 Jan 2002 07:55:02 -0800 (PST)
> > To: Faye Keesic <[EMAIL PROTECTED]>
> > Cc: [EMAIL PROTECTED]
> > Subject: Re: [PHP-DB] Date problem with new year
> >
> > Ah... the "$datetoget = ($datetoget-1)" is the problem.
> >
> > Convert the Gregorian Ymd date to Julian, subtract 1, then convert the
> > Julian date back to Gregorian (or Hebrew ;->). I've not had much success
> > with MySQL's date functions.
> >
> > On Wed, 2 Jan 2002, Faye Keesic wrote:
> >
> >> 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]
> >>
> >>
> >
> >
> > --
> > 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]
