Re: [PHP] Newbie MySQL INSERT Q

2003-03-14 Thread CPT John W. Holmes
> Can I have a single SQL string do INSERTS into multiple tables? No. ---John Holmes... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Newbie MySQL INSERT Q

2003-03-14 Thread Charles Kline
Can I have a single SQL string do INSERTS into multiple tables? Like: sql="INSERT INTO tbl_1 (id, email_address_1) VALUES ($v_personid, '$v_email'); INSERT INTO tbl_2 (person_id, interest_id) VALUES ($v_personid, $v_int1);"; Or do I need to break them up and use tw