Re: [PHP] Mysql Insert from select problem with php

2002-06-21 Thread Rasmus Lerdorf
I bet you are double-escaping it. Try without the AddSlashes() call. By default PHP will escape this for you automatically. -Rasmus On Thu, 20 Jun 2002, David McInnis wrote: After posting this on the MySQL list and getting some feedback we were able to determine that this was not a flaw

RE: [PHP] Mysql Insert from select problem with php

2002-06-21 Thread John Holmes
MySQL doesn't care about quotes when doing INSERT INTO ... SELECT. It's got to be something you're doing in PHP. Are you using that exact query? mysql create table list (clientid int, fname varchar(20)); Query OK, 0 rows affected (0.07 sec) mysql create table list2 (fname varchar(20)); Query