PHP does not allow ';' character in query strings so you'll have to break these.
regds, -----Original Message----- From: Charles Kline [mailto:[EMAIL PROTECTED] Sent: Friday, March 14, 2003 20:34 To: [EMAIL PROTECTED] Subject: Newbie MySQL INSERT Q 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 two of these? $result = $db->query($sql) Thanks Charles -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
