crag Posted March 9, 2006 Share Posted March 9, 2006 Hi. I am a newbie to php mysql and I hope you can help me with this small problem.I have 2 tables one named bandname with ID, bandname and contactIDa 2nd table named contactinfo with ID, name, tel, email.The data for inserting into the tables is taken from a form.->I firstly insert the contactinfo data into its table ->then i assign the bandname ID to a variable (contactid) using mysql_insert_id()->then i insert the bandname and contactid into bandname table.My problem is this:When I submit the form data my code inserts the first record fine but when I try to submit a second record it inserts 3 records. 1 record that is fine and another two that are a mix of the two correct records.if(isset($_POST['name'])) { $name = $_POST['name']; $tel = $_POST['tel']; $email = $_POST['email']; $sql1 = "INSERT INTO contactinfo SET name = '$name', tel = '$tel', email = '$email'"; if(isset($_POST['bandname'])) { $bandname = $_POST['bandname']; $contactid = mysql_insert_id(); $sql2 = "INSERT INTO bandname SET bandname = '$bandname', contactid = '$contactid'"; if((@mysql_query($sql1) && (@mysql_query($sql2)) { echo '<p>The contact info has been added to the database</p>'; } else { echo '<p>Error submitting contact info: ' . mysql_error() . '</p>'; } }}Can anyone please tell me what is wrong heresorry I didn't use a code tag.[code]if(isset($_POST['name'])) { $name = $_POST['name']; $tel = $_POST['tel']; $email = $_POST['email']; $sql1 = "INSERT INTO contactinfo SET name = '$name', tel = '$tel', email = '$email'"; if(isset($_POST['bandname'])) { $bandname = $_POST['bandname']; $contactid = mysql_insert_id(); $sql2 = "INSERT INTO bandname SET bandname = '$bandname', contactid = '$contactid'"; if((@mysql_query($sql1) && (@mysql_query($sql2)) { echo '<p>The band name has been added to the database</p>'; } else { echo '<p>Error submitting band name: ' . mysql_error() . '</p>'; } } }[/code] Quote Link to comment https://forums.phpfreaks.com/topic/4522-inserting-into-multiple-tables/ Share on other sites More sharing options...
crag Posted March 9, 2006 Author Share Posted March 9, 2006 solved Quote Link to comment https://forums.phpfreaks.com/topic/4522-inserting-into-multiple-tables/#findComment-15810 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.