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