ตารางที่มีความสัมพันธ์กัน ใช้ยังไงหรอคะ อันที่จริงเคยถามแล้ว แต่ยังไม่มีคนตอบให้ชัดเจน

		if(isset($_REQUEST["del_loc"])){ 
		$sql_loc  = "DELETE FROM location WHERE  locCode=".$_REQUEST["locCode"]." and admin_id=".$_SESSION["admin_id"]; 
		mysql_query($sql_loc)or  die(mysql_error());
		?>
		
<?php
	}
	if(isset($_POST["add_loc"]))
	{
		$result_loc = mysql_query( "SELECT * FROM location where locName='".$_POST["locName"]."'");
		if(mysql_num_rows($result_loc)<=0){
		$locIcon = uploadIcon($_FILES['locIcon']['name'],$_FILES['locIcon']['tmp_name'],$_FILES['locIcon']['size'],$_FILES['locIcon']['type']);
		$locImage = uploadImage($_FILES['locImage']['name'],$_FILES['locImage']['tmp_name'],$_FILES['locImage']['size'],$_FILES['locImage']['type']);

		$latlng = str_replace("(","",$_POST["locLatLng"]);
		$latlng = str_replace(")","",$latlng);

		$sql = "INSERT INTO location(admin_id ,locIcon,locImage,locLatLng,locName,locAddress,locTel,loc_bus,locDetail,locType) VALUES('".$_SESSION["admin_id"]."','".$locIcon."','".$locImage."','".$latlng."','".$_POST["locName"]."','".$_POST["locAddress"]."','".$_POST["locTel"]."','".$_POST["loc_bus"]."','".$_POST["locDetail"]."','".$_POST["locType"]."')";
		mysql_query($sql)or  die(mysql_error());
		?>
			<script type="text/javascript">
				$.prompt('เพิ่มตำแหน่งสำเร็จ');
			</script>
		<?php
		}else
			{
		?>
			<script type="text/javascript">
				$.prompt('กรุณาตรวจสอบชื่อตำแหน่งใหม่');
			</script>
		<?php
			}
	}
	
	if(isset($_POST["edit_loc"]))
	{
		$editname = "";	
		if($_POST["locName"]!=$_POST["loc_name_old"])
		{
			$result_loc = mysql_query( "SELECT * FROM location where locName='".$_POST["locName"]."' ");
			if(mysql_num_rows($result_loc)<=0)
			{
				$editname .= " locName='".$_POST["locName"]."',";
			}else
				{
		?>
				<script language="javascript">
					alert("ชื่อสถานที่ซ้ำ กรุณาป้อนชื่อใหม่");
				</script>
				<?php
				}
		}

		$locIcon = uploadIcon($_FILES['locIcon']['name'],$_FILES['locIcon']['tmp_name'],$_FILES['locIcon']['size'],$_FILES['locIcon']['type']);
		$locImage = uploadImage($_FILES['locImage']['name'],$_FILES['locImage']['tmp_name'],$_FILES['locImage']['size'],$_FILES['locImage']['type']);

		if($locIcon!=""){
			$editname .= "  locIcon='".$locIcon."',";
		}	
		if($locImage!=""){
			$editname .= "  locImage='".$locImage."',";
		}	
		$latlng = str_replace("(","",$_POST["locLatLng"]);
		$latlng = str_replace(")","",$latlng);
				
		$sql = "UPDATE location SET ".$editname." locLatLng='".$latlng."',locName='".$_POST["locName"]."',locAddress='".$_POST["locAddress"]."', locTel='".$_POST["locTel"]."',loc_bus='".$_POST["loc_bus"]."',locDetail='".$_POST["locDetail"]."',locType='".$_POST["locType"]."' WHERE locCode=".$_POST["locCode"].$userupdate;
		mysql_query($sql)or  die(mysql_error());
		?>
						<script language="javascript">
										alert("แก้ไขข้อมูลสำเร็จ");
										window.location = "?";
						</script>
		<?php	
}
?>