[PHP-DB] mysql/php time out issue

2010-04-09 Thread Stephen Sunderlin
I'm running php 5.1.6 with mysql 5.0.45 on CentOS 5.3 box trying to loop through a while statement to send about 3000 email using phpmailer. It's worked well in the past but after an upgrade it seems to be timing out now after 200-300 emails over 1 minute or two. I've added set_time_limi

[PHP-DB] Echoing a variable within a variable.

2009-01-06 Thread Stephen Sunderlin
I'm emailing an html file through phpmailer and the sql look up is getting the html from a table and setting it into a variable. Within the html from the table are also variables that are also being called by the same sql that is looking up the html variable. However the variable in the html are

[PHP-DB] Phpmailer sending duplicate messages...

2007-11-01 Thread Stephen Sunderlin
It seems to be ccing each email to everyone and I'd like it to only include one email address with each email. I've tested in on three of my personal emails and I see to get six messages in my inbox. I'm also sending about 4000 emails and would like some pointers to avoid time out errors. Finall

[PHP-DB] Trouble with Text Area

2007-10-31 Thread Stephen Sunderlin
When I put his line outside of the php tags I get the correct size: When I put this line inside the php tags the size comes out about 2 rows by 10 columns regardless of the value of rows and cols. Any ideas on how to format this would be greatly appreciated. The mySQL db column TYPE I am cal

RE: [PHP-DB] Re: backup of database record before update

2007-10-30 Thread Stephen Sunderlin
Neil, Have you had success with triggers. I couldn't get one to work and then saw discussion on the board here that MYSQL triggers were not so reliable and still somewhat problematic so I archive through the application. Just curious. -Original Message- From: Neil Smith [MVP, Digital

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

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

2007-09-22 Thread Stephen Sunderlin
e it, of course, if you may be presenting the datetime value in different ways, or if you want the flexibility, then use php. I hope this helps somewhat. -Original Message- From: Stephen Sunderlin [mailto:[EMAIL PROTECTED] Sent: Saturday, September 22, 2007 9:24 PM To: 'Naintara'

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

2007-09-22 Thread Stephen Sunderlin
hould 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. -Original Message- From: Stephen Sunderlin [mailto:[EMAIL PROTECTED] Sent: Saturday, September 22, 2007 7:48 PM To: '

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

2007-09-22 Thread Stephen Sunderlin
I'm getting the above NOTICE with the following statement: Echo date('d/m/y',$CTS); Where $CTS = 2007-09-22 10:09:31 And 31/12/69 is being echoed. PHP 5.2.1 MYSQL 5.0.37-community-nt via tcp/ip Thanks in advance for any insight. -- PHP Database Mailing List (http://www.php.net/) To unsubscri