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 O

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

2002-06-20 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 w