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='.addslashes($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 execute the following:

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 in INSERT statements, but when I

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