Re: Am I asking too much?

For security reasons mysql_query does not support ; to separate queries. phpmyadmin splits multiple query strings up (PMA_splitSqlFile()) John Taylor-Johnston wrote:

$sql1 works, but $sql2 doesn't. Am I asking too much? :=) $sql2 echoes ok. If I copy it and run it in phpmyadmin, it works, but this way as php code, it flunks out when I add: DELETE FROM '.$db.'.'.$table.' WHERE id='.$id.' LIMIT 1; Ideas? John ------------ snip ----------------- $sql1 = 'insert into '.$db2.'.'.$table2.' (RNum,YR,AU,ST,SD,SC,BT,BD,BC,AT,AD,AC,SR,PL,PR,JR,VNum,INum,DT,PG,LG,SF,OL,KW,AUS,GEO,AN,RB,CO,RR) select RNum,YR,AU,ST,SD,SC,BT,BD,BC,AT,AD,AC,SR,PL,PR,JR,VNum,INum,DT,PG,LG,SF,OL,KW,AUS,GEO,AN,RB,CO,RR FROM '.$db.'.'.$table.' WHERE id='.$id.';'; mysql_query($sql1); ------------ snip ----------------- $sql2 = 'insert into '.$db2.'.'.$table2.' (RNum,YR,AU,ST,SD,SC,BT,BD,BC,AT,AD,AC,SR,PL,PR,JR,VNum,INum,DT,PG,LG,SF,OL,KW,AUS,GEO,AN,RB,CO,RR) select RNum,YR,AU,ST,SD,SC,BT,BD,BC,AT,AD,AC,SR,PL,PR,JR,VNum,INum,DT,PG,LG,SF,OL,KW,AUS,GEO,AN,RB,CO,RR FROM '.$db.'.'.$table.' WHERE id='.$id.'; DELETE FROM '.$db.'.'.$table.' WHERE id='.$id.' LIMIT 1;'; mysql_query($sql2);