[PHP-DB] Date Help

--MS_Mac_OE_3066812333_145812_MIME_Part Content-type: text/plain; charset="US-ASCII" Content-transfer-encoding: 7bit When I want to subtract a day from a date, and pass the date to a function that will do the subtraction and then return the new value, so why does php sometimes subtract the year, i

[PHP-DB] Passing form values with quotes, to itself

Hi there. I have a form that contains several fields w/ text info (which may or may not contain single and double quotes). When the user clicks Preview, the form's action is set to call itself ($PHP_SELF), and the info is displayed nicely so they can read it over, and verify it before saving to

Re: [PHP-DB] Passing form values with quotes, to itself

utton to preview it, editted it again, previewed it again, etc. 10 times before they saved it to the db, they wouldn't get slashes before single and double quotes. What we do for end-users -- Faye Keesic Computer Programmer Analyst/Web Page Design > From: "Peter Lovatt" <

[PHP-DB] optimize table problem

Hi again. When I try to optimize a data table, I get this error: Optimize error: The handler for the table doesn't support check/repair. Is there something in mysql's settings that I need to change? -- Faye Keesic -- PHP Database Mailing List (http://www.php.net/) To unsubscr

[PHP-DB] MySQL query help - limit and group by

Hi there. I would like to return the 2 most recent events from my table, for each author (Author_ID). Here's my table structure (simplified). tblEvents ID Title Create_Date Author_ID Is there a way to do this with a query instead of getting every record, sorted by Author_ID, displaying the fir

[PHP-DB] Slow php processing

Hi there, In the past 24 hours, my php pages for one site have gone from 2 seconds loading time to nearly 2 minutes. What may have caused this degradation? I have not modified any of my php code, so think it may be a problem on the server, or with the database. However, not all my php database

[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. --

Re: [PHP-DB] Date problem with new year

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

Re: [PHP-DB] Date problem with new year

$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:

[PHP-DB] Problem with mail function

don't manually stop the browser after say, 10 seconds, the recipients in the email table get the email more than one time. Maybe I shouldn't be trying to send that many emails at a time. I am on apache using mysql and php... -- Faye Keesic Computer Programmer Analyst/Web Page Design

Re: [PHP-DB] Problem with mail function

) is a php weakness??? -- Faye Keesic Computer Programmer Analyst/Web Page Design >> From: [EMAIL PROTECTED] >> Date: Mon, 14 Jan 2002 09:51:54 -0800 (PST) >> To: Faye Keesic <[EMAIL PROTECTED]> >> Cc: [EMAIL PROTECTED] >> Subject: Re: [PHP-DB] Problem with mail f

Re: [PHP-DB] Problem with mail function

today. Another option i might implement is utilizing a mailing list manager, such as Majordomo or something. Thanks for all your help, the open source community is the best. -- Faye Keesic Computer Programmer Analyst/Web Page Design > From: [EMAIL PROTECTED] > Date: Tue, 15 Jan 2002 14:57:21

[PHP-DB] Quotes in db fields

d use stripslashes only when I am outputting the fields to the web pages Note: I started to use stripslashes because I was getting many slashes in front of any quotes the number of slashes doubled each time the form was previewed... -- Faye Keesic Computer Programmer Analyst/Web Page Design --