DaniWeb Forum Index > Web Development > PHP

plz..i need a help..

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

•

Join Date: Nov 2007

Posts: 16

Reputation: dbayo is an unknown quantity at this point

Solved Threads: 0

dbayo

Offline

Newbie Poster

plz..i need a help..

Dec 14th, 2007

ello..im a new beginner for pHp script..i have to complete my final project..i used php as my programming language..but,i have a problem rite now..did anybody know,how to insert data from 1 form into multiple tables in MySql Database?..

ok,rite now,i have 2 tables, Client and Client2,k..And from 1 form that i created ,i want to add the information from the form into table Client and Client2..anybody Know?...plz help me..;(

•

Join Date: Nov 2007

Posts: 596

Reputation: buddylee17 has a spectacular aura about

Solved Threads: 125

buddylee17 buddylee17 is offline

Offline

Posting Pro

Re: plz..i need a help..

Dec 14th, 2007

Assuming you already know how to connect to the database and that your form method was post:

 Help with Code Tags 
 php Syntax (Toggle Plain Text) 
$name=$_POST['name'];
$age=$_POST['age'];
$sql="INSERT INTO Client (name,age) VALUES ('$name','$age')";
$result=mysql_query($sql) or die(mysql_error());
$sql="INSERT INTO Client2 (name,age) VALUES ('$name','$age')";
$result=mysql_query($sql) or die(mysql_error());
$name=$_POST['name'];
$age=$_POST['age'];
$sql="INSERT INTO Client (name,age) VALUES ('$name','$age')";
$result=mysql_query($sql) or die(mysql_error());
$sql="INSERT INTO Client2 (name,age) VALUES ('$name','$age')";
$result=mysql_query($sql) or die(mysql_error());