Re: [PHP-DB] Re: Stuck in apostrophe hell

2010-08-04 Thread Simcha Younger
paul_s_john...@mnb.uscourts.gov wrote: THE INPUT: $sql_insert_registration = sprintf(INSERT INTO Registrations ( Class_ID, prid, Registrant, Company, Phone, Email ) VALUES ( $_POST[Class_ID], $_POST[prid], '%s',. You

RE: [PHP-DB] Re: Stuck in apostrophe hell

2010-08-04 Thread Ford, Mike
-Original Message- From: Simcha Younger [mailto:sim...@syounger.com] Sent: 04 August 2010 08:19 paul_s_john...@mnb.uscourts.gov wrote: THE INPUT: $sql_insert_registration = sprintf(INSERT INTO Registrations ( Class_ID, prid, Registrant,

[PHP-DB] Re: Stuck in apostrophe hell

2010-08-04 Thread Paul_S_Johnson
OK, I figured it out. I followed the advice here to turn on MySQL logging (which took more doing that it should have), so I could see what's really being sent to MySQL. It wasn't choking on the query I posted in my message but a later one in which the string was not escaped. The red herring

[PHP-DB] Re: Stuck in apostrophe hell

2010-08-03 Thread Paul_S_Johnson
Yes, I may have mixed up the input and output from different iterations of running it. Let me try posting this again although it may not be an issue. Once again if I enter two sequential apostrophes in the name (O''Brien) the INSERT passes right through to MySQL without an error. THE INPUT:

Re: [PHP-DB] Re: Stuck in apostrophe hell

2010-08-03 Thread Peter Lind
On 3 August 2010 15:04, paul_s_john...@mnb.uscourts.gov wrote: Yes, I may have mixed up the input and output from different iterations of running it. Let me try posting this again although it may not be an issue. Once again if I enter two sequential apostrophes in the name (O''Brien) the

Re: [PHP-DB] Re: Stuck in apostrophe hell

2010-08-03 Thread Chris
On 03/08/10 23:04, paul_s_john...@mnb.uscourts.gov wrote: Yes, I may have mixed up the input and output from different iterations of running it. Let me try posting this again although it may not be an issue. Once again if I enter two sequential apostrophes in the name (O''Brien) the INSERT

Re: [PHP-DB] Re: Stuck in apostrophe hell

2010-08-03 Thread Karl DeSaulniers
On Aug 3, 2010, at 8:08 AM, Peter Lind wrote: On 3 August 2010 15:04, paul_s_john...@mnb.uscourts.gov wrote: Yes, I may have mixed up the input and output from different iterations of running it. Let me try posting this again although it may not be an issue. Once again if I enter two

Re: [PHP-DB] Re: Stuck in apostrophe hell

2010-08-03 Thread Karl DeSaulniers
On Aug 3, 2010, at 5:44 PM, Chris wrote: On 03/08/10 23:04, paul_s_john...@mnb.uscourts.gov wrote: Yes, I may have mixed up the input and output from different iterations of running it. Let me try posting this again although it may not be an issue. Once again if I enter two sequential

[PHP-DB] Re: Stuck in apostrophe hell

2010-08-03 Thread David Robley
paul_s_john...@mnb.uscourts.gov wrote: Yes, I may have mixed up the input and output from different iterations of running it. Let me try posting this again although it may not be an issue. Once again if I enter two sequential apostrophes in the name (O''Brien) the INSERT passes right through