insert ค่า ในตารางรูปแบบหนึ่ง ส่งสู่ ค่าตารางอีกรูปแบบหนึ่ง

<?

	$sql = "SELECT *  FROM  table1";
	$query = mysql_query($sql);	
	
	while($fetch_array = mysql_fetch_array($query)){	
		$ref_Date = $fetch_array[ref_Date];
		$bungalow  = $fetch_array[bungalow ];
		$building  = $fetch_array[building ];
		$tent  = $fetch_array[tent];
		$sql_insert1 = "insert into table2  values('$ref_Date','bungalow','$bungalow')";
		mysql_query($sql_insert1);	
		$sql_insert2 = "insert into table2  values('$ref_Date','building','$building')";
		mysql_query($sql_insert2);	
		$sql_insert3 = "insert into table2  values('$ref_Date','tent','$tent')";
		mysql_query($sql_insert3);			
	}

?>