ขอถามวิธิการเพิ่มข้อมูลสองตารางพร้อมกัน โดยมีตารางหลัก และรายละเอียดตาราง

<?
	session_start();
?>
<?php

    include_once("function/DatabaseSetting.php");
?>
	
<?php
	$con = mysql_pconnect(DB_SERVER,DB_USERNAME,DB_PASSWORD);
	if (!$con)
	  {
	  die('Could not connect: ' . mysql_error());
	  }
	
	mysql_select_db(DB_DATABASE_NAME, $con);
	
	$sql="INSERT INTO payequip (per_id, pay_date)
	VALUES('$_POST[per_id]','$_POST[pay_date]')";	
		
	if (!mysql_query($sql,$con))
	  {
	  die('Error: ' . mysql_error());
	  }
	  
	$sql1="INSERT INTO payequip_detail (me_id, amount)
	VALUES('$_POST[me_id]','$_POST[amount]')";	 

	if (!mysql_query($sql1,$con))
	  {
	  die('Error: ' . mysql_error());
	  } 
	
	mysql_close($con)
?>

<?php	
	
	//include("RetrieveProductAction.php");
	
	$_REQUEST["action"] = "order/readDataOrderAction";
	include("ActionController.php");
	
	
?>

<?
$host="DB_SERVER";
$user="DB_USERNAME";
$pswd="DB_PASSWORD";
$dbname="ชื่อฐานข้อมูลคุณอ่ะ";

$con = mysql_connect($host,$user,$pswd) or die(mysql_error());
if (!$con) {
 echo "Can't connect to database";
}
else {
$sql1="INSERT INTO payequip (per_id, pay_date) VALUES('$_POST[per_id]','$_POST[pay_date]')";
$sql2="INSERT INTO payequip_detail (me_id, amount) VALUES('$_POST[me_id]','$_POST[amount]')";

     $query1=mysql_db_query($dbname,$sql1);
     $query2=mysql_db_query($dbname,$sql2);

          $chk_row1=mysql_num_rows($query1);
          $chk_row2=mysql_num_rows($query2);

if ($chk_row1 && $chk_row2) {
 echo "<h4> Save Successful.";
}
else {
 echo "Error Query";
}

}

mysql_close($con)
?>

$con = mysql_connect("DB_SERVER","DB_USERNAME","DB_PASSWORD") or die(mysql_error());

     $query1=mysql_db_query($dbname,$sql1) or die(mysql_error());
     $query2=mysql_db_query($dbname,$sql2); or die(mysql_error());

<?
	session_start();
?>
	
<?php
	$con = mysql_pconnect('localhost','root','12345');
	if (!$con)
	  {
	  echo "Can't connect to database"; 
	  }
	
	mysql_select_db(DB_DATABASE_NAME, $con);
	
	$sql="INSERT INTO payequip (per_id, pay_date) VALUES('$_POST[per_id]','$_POST[pay_date]')";	
		
	if (!mysql_query($sql,$con))
	  {
	  echo "Error Query";
	  }
	else {
		echo "<h4> Save 1 Successful."; 
	}
	
	  
	$sql1="INSERT INTO payequip_detail (pay_id, me_id, amount) VALUES('$_POST[pay_id]','$_POST[me_id]','$_POST[amount]')
                            SELECT pay_id FROM payequip";	
		    

	if (!mysql_query($sql1,$con))
	  {
	  echo "Error Query1";
	  } 
	  else {
		echo "<h4> Save 2 Successful."; 
	}
	
	mysql_close($con)
?>

if (!mysql_query($sql,$con))
{
mysql_error();
}
else {
ech