Linking two tables on one page.

MBK

I am trying to create a page that updates info into two tables in the same database.
How do I do this pls?
I am getting a parse error at present, here is a copy of the script.

[insert.php]

<?
mysql_connect('localhost','root');
@mysql_select_db('reseller')or die("Unable to connect to database");

$company=$POST['company'];
$address=$POST['address'];
$address2=$POST['address2'];
$county=$POST['county'];
$postcode=$POST['postcode'];
$tel=$POST['tel'];
$fax=$POST['fax'];
$web=$POST['web']

//info to go into seperate table - contact
$first=$POST['first'];
$surname=$POST['surname'];
$position=$POST['position'];
$phone=$POST['phone'];
$email=$_POST['email'];

mysql_connect('localhost','root');
@mysql_select_db('reseller')or die("Unable to connect to database");

$query="INSERT INTO company VALUES('$company','$address','$address2','$county','$postcode',
'$tel','$fax','$web')";

mysql_query($query);

$query1="INSERT INTO contact VALUES('$first','$surname','$position','$phone','$email')";

mysql_query($query1);

$query="SELECT * FROM company";
$result=mysql_query($query);
$num=mysql_numrows($result);

$query1="SELECT * FROM contact";
$result1=mysql_query($query1);
$num1=mysql_numrows($result1);

mysql_close();

echo "<center>Database Output</center> ";

$i=0;
while($i<$num){

$first=mysql_result($result,$i,"first");
$last=mysql_result($result,$i,"last");
$phone=mysql_result($result,$i,"phone");
$mobile=mysql_result($result,$i,"mobile");
$fax=mysql_result($result,$i,"fax");
$email=mysql_result($result,$i,"email");
$web=mysql_result($result,$i,"web");

echo "$first $last Phone:$phone Mobile:$mobile Fax:$fax E-mail:$email
 Web:$web <hr> ";

++$i;
}

?>
</body>
</html>

frigidman

Well for starters, you are doing TWO mysql database connections? No. Just one per database is needed at the begginning of the script.

Second... you are forgetting to close the queries and assign the query handles into a variable to use... you have too many queries all going at once all stepping over each other (I NEVER make a query I dont close right afterwards).

You also have a serious lack of handle assignments...

And you are throwing a mysql_close right in the middle of your script before using some mysql functions referencing mysql handles to queries.

//you need to put the connection handle into a var:
$connectionhandle = mysql_connect('localhost','root');

//for insert/update/delete use:
$queryhandle = mysql_query($query,$connectionhandle);
@mysql_free_result($queryhandle);

//for selects use:
$queryhandle = mysql_query($query,$connectionhandle);
//now output your code
while ($row = mysql_fetch_array($queryhandle)) {
echo "$row[first] $row[last] Phone:$row[phone] Mobile:$row[mobile] Fax:$row[fax] E-mail:$row[email]
 Web:$row[web] <hr> ";
}
@mysql_free_result($queryhandle);

You can also store the rows into an array and loop through them later. I do this all the time. I store the fetched rows into a big multi dim array to be used later in the code, so I open/get/close the query at any time without having to paste that into html areas. But whatever.

Hard to say what is your main problem... they could all be causing a headache. Try to be orderly with your mysql queries... dont start another before closing a previous one. Even though you use different handler names... its still better to close one before starting another. And don't use mysql_close()... The mysql connection will close at the end of the php execution, and I've found it rare to close ahead of this.

MBK

Thanks for the reply.
About what you are saying re: storing the rows into an array, how does this work, do you have any examples you could post?