(จะรอคำตอบจากกระทุ้นี้ ครั้งสุดท้ายแล้ว) ต้องการ alert เมื่อตอนบันทึกข้อมูล..

<?php
$sql = "INSERT INTO tb_cmp VALUES(NULL,'$userNameID','$cmpName','$brandID')";
$result = mysql_query($sql) or die ("<script>alert('Cannot save data');history.back();</script>");

$sqlTB = "SELECT * FROM tb_cmp INNER JOIN tb_brandCmp
ON tb_brandCmp.brandID = tb_cmp.brandID
INNER JOIN tb_usename
ON tb_userName.userNameID = tb_cmp.userNameID
WHERE tb_cmp.brandID = tb_brandCmp.brandID
AND tb_cmp.userNameID = tb_userName.userNameID
AND cmpID='" . mysql_insert_id() . "'"; // อ้างอิงโดยที่ใช้ id ที่ insert ลง tb_cmp อันล่าสุด

$resultTB = mysql_query($sqlTB) or die ("$sqlTB_Error");
$rowTB = mysql_fetch_array($resultTB);

$userName = $rowTB['userName'];
$brandName = $rowTB['brandName'];
$model = $rowTB['model'];
$description = $rowTB['description'];

echo "<script>alert('UserName : $userName\\ncmpName : $cmpName\\nBrand name : $brandName\\nModel : $model\\nDecription : $description\\nSaving completed.\\n(total : $result record)');window.location='FRMcmp.php';</script>";
exit();

?>