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], > > $_PO

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, > > > pri

[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 that