การเปลี่ยนสี่ของแต่ช่องโดยการตรวจสอบข้อมูลจากฐานข้อมลก่อน

<tr>
      <td width="40" height="32" bgcolor="<? echo getcolor(4);?>"><img src="../../images/1.jpg" width="40" /></td>
      <td width="40" height="32" bgcolor="<? echo getcolor(8);?>"><img src="../../images/1.jpg" width="40" /></td>
      <td width="40" height="32" bgcolor="<? echo getcolor(12);?>"><img src="../../images/1.jpg" width="40" /></td>
      <td width="40" height="32" bgcolor="<? echo getcolor(16);?>"><img src="../../images/1.jpg" width="40" /></td>
      <td width="40" height="32" bgcolor="<? echo getcolor(20);?>"><img src="../../images/1.jpg" width="40" /></td>
      <td width="40" height="32" bgcolor="<? echo getcolor(24);?>"><img src="../../images/1.jpg" width="40" /></td>
      <td width="40" height="32" bgcolor="<? echo getcolor(26);?>"><img src="../../images/1.jpg" width="40" /></td>
      <td width="40" height="32" bgcolor="<? echo getcolor(30);?>"><img src="../../images/1.jpg" width="40" /></td>
      <td width="40" height="32" bgcolor="<? echo getcolor(34);?>"><img src="../../images/1.jpg" width="40" /></td>
      <td width="40" height="32" bgcolor="<? echo getcolor(40);?>"><img src="../../images/1.jpg" width="40" /></td>
    </tr>

<?
             function getcolor($a){
		      include "../../connect.php";
			  
		 
		      $sql="select * from booking where Discount=''";
			  $result1=mysql_db_query($dbname,$sql);
			  $r1=mysql_fetch_array($result1);
			  $id_tour=$r1[id_tour];
			  
			  $sql="select chair from chair where id_program='$id_tour'";
			  $result2=mysql_db_query($dbname,$sql);
			  while($r2=mysql_fetch_array($result2)){
			  $chair=$r2[chair];
			  if($chair==4 or $chair==3 or $chair==8 or $chair==10){		
		      $color="#003333";
               return $color;
			   }
	          else{
		      $color1="#0000FF";
	          return $color1;
			   }	 
			   }
			  }
			  ?>