how to insert data into two table using in php mysql

i just want to insert data into two table using single query in php mysql. and also one table has multiple row. please help me... my code is bellow .

 

Hi..

 try it..

Nname:


Password:


Address:


Phone No:

$con= mysql_connect("localhost","root","");
mysql_select_db("phptutor",$con);
if (!$con){
die('could not connect'.mysql_error);
}

@$a=$_POST['Uname'];
@$b=$_POST['Upass'];
@$c=$_POST['Uadrs'];
@$d=$_POST['Uph'];

if(@$_POST['addval'])
{
$sql="insert into tbl_insert_data(User_name,User_pass,User_address,User_ph) values('".$a."','".$b."','".$c."','".$d."')";
echo "insert data";
mysql_query($sql);
}


$con= mysql_connect("localhost","root","");
mysql_select_db("phptutor",$con);
if (@$_POST['showdata'])
{
echo $show_result=mysql_query("select User_name,User_pass,User_address,User_ph from tbl_insert_data");
echo "








";
while($row=mysql_fetch_array($show_result))
{
echo "";
echo "";
echo "";
echo "";
echo "";

echo "";

}

}
echo "

All User
User_name	User_pass	User_address	User_ph
".$row['User_name']."	".$row['User_pass']. "	".$row['User_address']."	".$row['User_ph']."

"

?>

Check my video...How to create function and procedure in mysql database.

 

Thanks..

thanks for send this answer .but it is not working in page......

please modify my code which are wrong ..

please help me

 

thanks 

hi saroj 

 

read this link

 

http://stackoverflow.com/questions/22384391/insert-data-into-2-tables-using-one-query-using-php-and-mysql 

 

itmay help you