Thank for the info so far. Let I modify to a more exact example
PHP Code:
$id = $_POST['id']; //primary key: name table, foriegn key: other tables
$fname = $_POST['fname'];
$lname = $_POST['lname'];
$town = $_POST['town'];
$parish = $_POST['parish'];
$cell = $_POST['cell'];
$fax = $_POST['fax'];
$brand = $_POST['brand'];
$type = $_POST['type'];
$query = ("INSERT INTO name (id,fname,lname,..) VALUES ('$id','$fname','$lname',..)") or die(mysql_error());
$query = ("INSERT INTO address (id,town,parish,..) VALUES ($id','$town','$parish',..)") or die(mysql_error());
$query = ("INSERT INTO phone (id,cell,fax,..) VALUES ('$id','$cell','$fax',..)") or die(mysql_error());
$query = ("INSERT INTO computer (id,brand,type,..) VALUES ('$id','$brand','$type',..)") or die(mysql_error());
mysql_query($query)or die(mysql_error());
This is what I have for the query:
PHP Code:
$query = mysql_query('SELECT * FROM name, address, phone, computer')or die (mysql_error());
while ($result = mysql_fetch_array($query))
{
echo $result['fname'];
//other echo statements
}