[Resolved] [Resolved] [Resolved] Inserting In multiple Tables

[artisticre]

I need help. I am trying to learn mysql & php by myself.

I have two tables I want to insert to at the same time

NAME
nameID
name
phoneID

Phone
phoneID
phone

Here is the code to my form
<form enctype="multipart/form-data" method="post" name="form" action="/Specialty/PHP/add_data.php3">
Name<br>
<input type="Text" name="name" size="25">
<br>
Number<br>
<input type="Text" name="number" size="25">
<br>
<input type="submit" name="submit" value="Upload">
</form>

Can someone please give me the code to insert into multiple tables so I can pick it apart and learn from it?

Thanks

[Ortega]

//make a file, put this in, and include that file using require("file");
    /* Connecting & selecting database */
    mysql_connect("hostname", "username", "password")or die("Could not connect");
    mysql_select_db("database") or die("Could not select database");

//get the variables from post, you could also use a for loop to get all vars
$nameID = $_POST['nameID'];
$name = $_POST['name'];
...

//insert into mysql database
mysql_query("INSERT INTO `NAME` (`nameID`, `name`) VALUES ('$nameID', '$name')") or die(mysql_error());

[artisticre]

OK I modified it so the phone table is populated as well
$nameid = $POST['nameid'];
$name = $POST['name'];
$phoneid = $POST['phoneid'];
$phone = $POST['phone'];

mysql_query("INSERT INTO Name (nameid, name) VALUES ('$nameid', '$name')") or die(mysql_error());
mysql_query("INSERT INTO Phone (phoneid, phone) VALUES ('$nameid', '$number')") or die(mysql_error());

However, the phoneid in the name table is 0. This can't be right. Its almost like the relationship in the database isn't correct. Any ideas???😕