[PHP-DB] Stuck in apostrophe hell

2010-08-02 Thread Paul_S_Johnson
Before I send the following SQL to MySQL from PHP I print it to screen. PHP chokes on it, but I can paste the exact same query from the screen directly to MySQL and it works just fine. For example: Here's the relevant PHP code: == $sql_insert_registration =

Re: [PHP-DB] Stuck in apostrophe hell

2010-08-02 Thread Peter Lind
On 2 August 2010 22:30, paul_s_john...@mnb.uscourts.gov wrote: Before I send the following SQL to MySQL from PHP I print it to screen. PHP chokes on it, but I can paste the exact same query from the screen directly to MySQL and it works just fine. For example: Here's the relevant PHP code:

Re: [PHP-DB] Stuck in apostrophe hell

2010-08-02 Thread Niel Archer
Before I send the following SQL to MySQL from PHP I print it to screen. PHP chokes on it, but I can paste the exact same query from the screen directly to MySQL and it works just fine. For example: Here's the relevant PHP code: ==

Re: [PHP-DB] Stuck in apostrophe hell

2010-08-02 Thread Bret Hughes
I would turn on query logging and see what exactly is making it to mysql. Niel Archer wrote: Before I send the following SQL to MySQL from PHP I print it to screen. PHP chokes on it, but I can paste the exact same query from the screen directly to MySQL and it works just fine. For example:

Re: [PHP-DB] Stuck in apostrophe hell

2010-08-02 Thread Philip Thompson
On Aug 2, 2010, at 4:42 PM, Bret Hughes wrote: I would turn on query logging and see what exactly is making it to mysql. Niel Archer wrote: Before I send the following SQL to MySQL from PHP I print it to screen. PHP chokes on it, but I can paste the exact same query from the screen