Re: [PHP-DB] Pages not fully loading

2007-09-22 Thread ioannes
Thanks to all who replied. There is a lot of undefined index and undefined variables when I turn on error reporting. The error logs show 'file not found' errors in the last 24 hours for files that I am sure were never called from any script on my site. I do not understand 'mod_rewrite:

Re: [PHP-DB] Pages not fully loading

2007-09-22 Thread ioannes
The problem occurs without session data in the page also. Buffering is off on my php.ini file. Language Options output_buffering= Off I have been told that the MAIN error_log below also shows errors for other users on the server, so that does not help particularly. John ioannes wrote:

RE: [PHP-DB] Notice: A non well formed numeric value encountered

2007-09-22 Thread Naintara
I don't see the NOTICE message. Perhaps a timezone notice? Lookup the date() function in the php manual. The time parameter should be a unix timestamp value, so $CTS should contain an integer value. You can also find ways to convert the time value you have to unix timestamp, in the manual.

RE: [PHP-DB] Pages not fully loading

2007-09-22 Thread Naintara
Perhaps a faulty mod_rewrite rule or pages/folder setup. You'll need someone to look at your setup and mod_rewrite rules or if you want to read up on it http://httpd.apache.org/docs/1.3/mod/mod_rewrite.html -Original Message- From: ioannes [mailto:[EMAIL PROTECTED] Sent: Saturday,

RE: [PHP-DB] Notice: A non well formed numeric value encountered

2007-09-22 Thread Stephen Sunderlin
Thank you for your response. The notice is in the Subject Line of the email: Notice: A non well formed numeric value encountered So you are saying I have to convert the current -mm-dd:HH:MM:SS date format, to UNIX timestamp value then call Date() to format the UNIX timestamp as Month, Day,

Re: [PHP-DB] Pages not fully loading

2007-09-22 Thread ioannes
I also get this in my error log, I am not sure what to do with this (what side effect?): PHP Warning: Unknown(): Your script possibly relies on a session side-effect which existed until PHP 4.2.3. Please be advised that the session extension does not consider global variables as a source of

RE: [PHP-DB] Notice: A non well formed numeric value encountered

2007-09-22 Thread Naintara
That's a good question. I'm really not sure about which way is better, but yes, you could use UNIX_TIMESTAMP() to query a datetime value from a MySQL field, convert it to the UNIX timestamp value within the query, and then retrieve it in your record set. UNIX_TIMESTAMP() [MySQL function] Or

FW: [PHP-DB] Notice: A non well formed numeric value encountered

2007-09-22 Thread Naintara
Hi again Stephen, Further on my previous post, if you do store the UNIX timestamp as an integer value, it should be very efficient, database storage and query speed, plus giving you ease and flexibility in formatting via php. -Original Message- From: Naintara [mailto:[EMAIL PROTECTED]

RE: [PHP-DB] Notice: A non well formed numeric value encountered

2007-09-22 Thread Stephen Sunderlin
I have 3 Timestamp fields in a contact manager that record Edit date, Create Date and Merge Date. Doesn't matter to me how it is stored at this point however when I tried to call it up as just Month, Day, Year (with out the timestamp) in php I got the A non well formed numeric value encountered

RE: [PHP-DB] Notice: A non well formed numeric value encountered

2007-09-22 Thread Naintara
I think for now you can use the MySQL function DATE_FORMAT() This would work well for your columns. Look it up in the MySQL reference, it's very easy to use. You'll have something like contact_created_date If a contact was created today, it'll be something like SELECT

RE: [PHP-DB] Notice: A non well formed numeric value encountered

2007-09-22 Thread Stephen Sunderlin
Naintara, That worked! I must have made a syntax error. Thank you! -Original Message- From: Naintara [mailto:[EMAIL PROTECTED] Sent: Saturday, September 22, 2007 1:34 PM To: 'Stephen Sunderlin' Cc: 'PHP-DB Mailing List' Subject: RE: [PHP-DB] Notice: A non well formed numeric value

RE: [PHP-DB] Notice: A non well formed numeric value encountered

2007-09-22 Thread Naintara
Glad I could help. The problem you faced earlier could happen if you tried to use the timestamp column values directly in the php date() function. If you see the database your timestamp columns would have values in the following format for its timestamp columns: '1970-01-01 00:00:01' This

[PHP-DB] Database warning may be session is the problem

2007-09-22 Thread Chris Carter
This might look only like a warning message but it has been bugging me since quite sometime now. Seek expert advice from the members of this forum please. Session at the top of the page; ? session_start(); if(!session_is_registered(emailAddress)){ header(location:store-login.php); }