View Single Post
  #1 (permalink)  
Old February 2nd, 2006, 02:43 PM
bmalex1 bmalex1 is offline
Registered User
 
Join Date: Feb 2006
Location: Dallas, Texas, USA.
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to bmalex1
Default How do I insert data into multiple table ?



Greetings to all,

I am new to this forum and fairly new to php/mysql.
I have been trying to learn how to insert data into multiple tables in mysql database. Here is a sample of the script that I use.........

<?php

@$link = mysql_connect(SYSTEM,USERNAME,PASSWORD);
if(!$link)
{
echo "Database seems to be down";
exit;
}

mysql_select_db(DATABASE) or die( "Unable to select database");

$query = "INSERT INTO 'table1','table2','table3' WHERE field1= ".$_POST['field1']." AND field2= ".$_POST['field2']." ";

$result = @mysql_query($query);
if(!$result)
{
echo "Error - Could not insert your data into the database.";
  echo mysql_error().'<br>';
}

mysql_close();

echo"
<html>

My problem is that mysql_error(). tells me there is an error in my syntax on line 1 which would be $query = ............

Can someone tell me what is wrong with my script and how to correct it?

Barry Alexander