[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 = sp

Re: [PHP-DB] Stuck in apostrophe hell

2010-08-02 Thread Peter Lind
On 2 August 2010 22:30, 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: > == > $sql_insert_reg

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: He

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