Inserting into multiple tables in MSQL

artisticre

OK this is what I have

$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???

please please help

chads2k2

$nameid = $POST['nameid'];
$name = $POST['name'];
$phoneid = $POST['phoneid'];
$phone = $POST['phone'];

OK....

<?php
// connect to the database prior to this code.

$sql1="Insert into name VALUES('$nameid','$name')";
mysql_query($sql1);
$sql2="INSERT INTO phone VALUES('$phoneid','$phone')";
mysql_query("$sql2);
?>

I didn't add in the dies...just because this code will work assuming you only have 2 fields per table. If this doesn't help then please provide how your table structure is. Thanks!

artisticre

the phoneid in the name table doesn't populate

CREATE TABLE Name (
nameid smallint(6) NOT NULL auto_increment,
name varchar(20) NOT NULL default '',
phoneid smallint(6) NOT NULL default '0',
PRIMARY KEY (nameid)
) TYPE=MyISAM;

CREATE TABLE Phone (
phoneid smallint(6) NOT NULL auto_increment,
phone varchar(20) NOT NULL default '',
PRIMARY KEY (phoneid)
) TYPE=MyISAM;

chads2k2

OHhh.... ok.... I am feeling ya now ... ok ... let me get this straight.

You want it to enter into the Phone table....get the phoneid and place it in the Name table under phoneid field?

Am I understanding this correctly? I had a double today at work so I am a little tired but shoot me back with a response and I can get ya an answer right quick.

Chad