$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
