การดึงข้อมูลจาก DB มาคำนวณ มีปัญหาครับ [ไม่แสดงผลในครั้งแรกที่คำนวณ]

$query1 = mysql_query("SELECT * FROM status WHERE id_status = '".$type."'");
$query2 = mysql_query("SELECT * FROM room WHERE id_room = '".$room."'");
$status = mysql_fetch_assoc($query1);
$status2 = mysql_fetch_assoc($query2);
$datein = $_POST['datein'];
$dateout = $_POST['dateout']; 
$numdate = $_POST['numdate']; 
$amount = $_POST['amount']; 
$exbed = $_POST['exbed']; 
$name = $_POST['name']; 
$tel = $_POST['tel']; 
$total = $_POST['total'];
$status_type =$status['id_status'];
$reserv_checkin = $status2['reserv'] + $status2['checkin'];
$room_ava = $status2['total'] - $reserv_checkin; 

if($type == '1'){
	$room_reserv =$status2['reserv']+$amount;
	$ins= mysql_query("INSERT INTO detail(id_detail,date_in,date_out,date_num,room_type,
	amount,extrabed,total_price,cus_name,telephone,status) 
VALUES ('', '$datein', '$dateout', '$numdate', '$room', '$amount', '$exbed', '$total'
, '$name', '$tel', '$status_type' )");
	$ins_room= mysql_query("UPDATE room SET 
	reserv='$room_reserv' WHERE id_room='$room'");

}
else {
	$room_checkin =$status2['checkin']+$amount;
	$ins= mysql_query("INSERT INTO detail(id_detail,date_in,date_out,date_num,room_type,
	amount,extrabed,total_price,cus_name,telephone,status) 
VALUES ('', '$datein', '$dateout', '$numdate', '$room', '$amount', '$exbed', '$total'
, '$name', '$tel', '$status_type' )");
	$ins_room= mysql_query("UPDATE room SET 
	checkin='$room_checkin' WHERE id_room='$room'");

}
	$ins_room2= mysql_query("UPDATE room SET 
	avaliable='$room_ava' WHERE id_room='$room'");