Am I asking too much?
| From: | John Taylor-Johnston | Date: | Fri, 10 Oct 2003 05:32:57 +0000 |
| Subject: | Am I asking too much? | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-165703@lists.php.net to get a copy of this message | ||
$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);