"ช่วยหน่วยนะคับ"ดึงข้อมูลจากฐานข้อมูล ผมต้องการดึงข้อมูลจากโดยให้ผิลสีฟ้าสัมพันกัน เพื่อนำฟิลสีแดงมาแสดง งงมั้ยอะ

select rs.id_room,rs.id_room,rs.id_reserv,tz.a from reserv rs
left join room rm on (rs.id_room=rm.id_room)
left join timezone tz on (rs.id_reserv=tz.id_resrv)

$sql4 =  mysql_query( "select * from reserve,timezone
						 where reserve.id_reserve=timezone.id_reserve and
						       reserve.date=timezone.date 
							    ") ;
							  while($l4 = mysql_fetch_array($sql4)){
							  
							  
							  if($l4[timezone.a]=='1')
							   {echo $l4[timezone.a];						   
							    }
							  else if($l4[timezone.a]!=='')
							   {echo "2";						   
							    }
							    else 
							   {echo "3";						   
							    }
							    
							   
							   
							   
							   
							   }

$sql4 =  mysql_query( "select rs.id_room,rs.id_room,rs.id_reserv,tz.a from reserv rs
left join room rm on (rs.id_room=rm.id_room)
left join timezone tz on (rs.id_reserv=tz.id_resrv)
") ;
							  while($l4 = mysql_fetch_array($sql4)){
							  
							  
							  if($l4[timezone]=='1')
							   {echo $l4[timezone];						   
							    }
							  else if($l4[timezone]!='')
							   {echo "2";						   
							    }
							    else 
							   {echo "3";						   
							    }
							    
							   
							   
							   
							   
							   }