Re: [PHP] Am I asking too much?

[Marek Kilimajer]

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);

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php