Re: [PHP-DB] Single quotes in INSERT statements?

2006-04-26 Thread dpgirago
> Skip Evans wrote: > >>Hello all, >> >>I'm brand spanking new to the list and have a >>quick question. >> >>I was under the impression that addslashes() would >>handle single quote marks in INSERT statements, >>but when I execute the following: >> >>$sql="UPDATE images SET orderno=$orderno, >>url

Re: [PHP-DB] Single quotes in INSERT statements?

2006-04-26 Thread Martin Alterisio
2006/4/26, [EMAIL PROTECTED] <[EMAIL PROTECTED]>: > > > > Skip Evans wrote: > > > >>Hello all, > >> > >>I'm brand spanking new to the list and have a > >>quick question. > >> > >>I was under the impression that addslashes() would > >>handle single quote marks in INSERT statements, > >>but when I ex

Re: [PHP-DB] Single quotes in INSERT statements?

2006-04-26 Thread dpgirago
Martin Alterisio wrote: >2006/4/26, [EMAIL PROTECTED] <[EMAIL PROTECTED]>: >> >> >> > Skip Evans wrote: >> > >> >>Hello all, >> >> >> >>I'm brand spanking new to the list and have a >> >>quick question. >> >> >> >>I was under the impression that addslashes() would >> >>handle single quote marks

Re: [PHP-DB] Single quotes in INSERT statements?

2006-04-26 Thread Skip Evans
Geez, did I start all this? I can see now that my initial assumption that addslashes() was not doing what it was supposed to do was wrong, and that I should have checked the DB before firing off the message. Clearly I should have done more investigation on my own. (Which is often the case.)

[PHP-DB] PostgreSQL functions missing

2006-04-26 Thread Tony Grimes
Hi, My sys admin installed an update to H-Sphere (control panel software) that broke PEAR::DB and phpBB last week. After much trial and error, I finally tracked it down to missing pg_affected_rows() and pg_cmdtuples() functions (for PEAR and phpBB respectively) in PHP. I'm assuming that the H-Sphe

Re: [PHP-DB] PostgreSQL functions missing

2006-04-26 Thread chris smith
On 4/27/06, Tony Grimes <[EMAIL PROTECTED]> wrote: > Hi, > > My sys admin installed an update to H-Sphere (control panel software) that > broke PEAR::DB and phpBB last week. After much trial and error, I finally > tracked it down to missing pg_affected_rows() and pg_cmdtuples() functions > (for PEA