Re: [PHP-DB] Please help count ?

2002-04-04 Thread Shane Wright
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 you can do this... $myvar = ecplode(' ', $postcode); $firsthalf = $myvar[0]; But not everyone puts the space in there S On Thursday 04 April 2002 5:29 pm, Dave Carrera wrote: > Hi All > > > > I have a variable returned by my application. > >

[PHP-DB] mySQL max connections

2002-07-30 Thread Shane Wright
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi I have a database thats taking a bit of a hammering - enough so that the number of connections spirals up and out of control. max_connections was originally at the default of 100 - but rising above 50 or so meant actual throughput dropped so t

Re: [PHP-DB] mySQL max connections

2002-07-30 Thread Shane Wright
or use cursor-right/left) > > -Rasmus > > On Tue, 30 Jul 2002, Shane Wright wrote: > > Hi > > > > I have a database thats taking a bit of a hammering - enough so that the > > number of connections spirals up and out of control. > > > > max_connect

Re: RE: [PHP-DB] sending bulk emails

2001-11-02 Thread Shane Wright
Hi If he's going to do it, it should at least be done safely... - have a status field in your database table (unsent/sent/error) - update the status field after _every_ email you send. - do NOT do this in a transaction (otherwise if something dies everything is forgotten) - if the update st

Re: [PHP-DB] sending bulk emails

2001-11-02 Thread Shane Wright
Hi I find that the best way to do it is with a script having a long/unlimited timeout, but limiting it to only a few hundred mails per execution in the SQL '... LIMIT 500'. IMO better this way than a short-timeout script - sending one email can sometimes take ages (long DNS lookup, slow conne

Re: [PHP-DB] sending bulk emails - mail() success/failure

2001-11-02 Thread Shane Wright
Hi > The mail() entry in the manual does say that it returns a boolean for send > success/failure, however none of the examples make any use of such > feedback. Is there a way to work out if something has gone wrong with a > particular mail out, what the actual failure was, eg SMTP server down,

Re: [PHP-DB] problem with pconnect

2001-12-11 Thread Shane Wright
Hi Markus I assume you're using Apache with PHP installed as a DSO? If not ignore my ramblings... AFAIK, the persistent connections are per-process - i.e. each Apache process gets its own [set of] persistent processes. But when you connect to apache, you rarely get the same process as you go