[report] เกี่ยวกับการดึงข้อมูลรายงาน ช่วยตรวจสอบให้ทีครับ

<form method=post action="" name="form1">
     <select name="sel" onchange="getTree()" id="sel">
              <option value="1">รายงานประจำวัน</option>
              <option value="2">รายงานประจำเดือน</option>
              <option value="3">รายงานประจำปี</option>
     </select>
  <span id="divTree"><input type="text" name="day"  onClick="return showCalendar('sel1', 'dd-mm-y');" id="sel1"></span>
              <input type="submit" value="   ดูรายงาน   " name="search">
</form>

<? if(!empty($search)){?>
<table border="1" cellspacing="0" cellpadding="0" bordercolor="#000000" bordercolordark="#FFFFFF" width="100%" align="center">
  <tr bgcolor="DDDDDD" height="25">
    <td align="center" width="57"><div align="center"><b>ลำดับ</b></div></td>
    <td width="180" align="center"><div align="center"><b>วันที่จอง</b></div></td>
    <td width="253" align="center"><div align="center"><b>ชื่อลูกค้า</b></div></td>
    <td width="131" align="center"><div align="center"><b>ที่นั่ง</b></div></td>
	<td width="171" align="center"><div align="center"><b>ต้นทาง</b></div></td>
	<td width="149" align="center"><div align="center"><b>ปลายทาง</b></div></td>
    <td align="center" width="142"><div align="center"><strong>ราคาตั๋ว</strong></div></td>
  </tr>

<?  if($sel=="3"){
$year=$year-543;
$sqlb = mysql_db_query("$dbname","SELECT distinct(reserve.Customer_ID), reserve_day,Seat FROM reserve where substr(reserve_day,7,4) like '%$year%' and  Customer_ID!='0'");//เลือกข้อมูล
}else if($sel=="2"){
$sqlb = mysql_db_query("$dbname","SELECT distinct(reserve.Customer_ID), reserve_day,Seat FROM reserve where substr(reserve_day,4,2) like '%$month%' and Customer_ID!='0'");//เลือกข้อมูล
}else{
$sqlb = mysql_db_query("$dbname","SELECT distinct(reserve.Customer_ID), reserve_day,Seat FROM reserve where reserve_day= '$day' and Customer_ID!='0'");//เลือกข้อมูล
}
$a=0;
while($rowsqlb=mysql_fetch_array($sqlb)){// เก็บข้อมูลที่เลือกมาจากคำสั่ง sql ลงใน ตัวแปล array
$sql = mysql_db_query("$dbname","SELECT (busroute.Price) FROM busroute, reserve where busroute.BusRoute_ID=reserve.BusRoute_ID and reserve.Customer_ID='$rowsqlb[Customer_ID]' order by (busroute.Price) desc");//เลือกข้อมูล
$rowsql=mysql_fetch_array($sql);// เก็บข้อมูลที่เลือกมาจากคำสั่ง sql ลงใน ตัวแปล array
$n=$n+1;
if ( $color == "#C3D9FF"){
     $color = "#f7f7f7";
} else {
     $color = "#C3D9FF";
     
} ?>
              <tr bgcolor="<?=$color?>">
                       <td align="center"><div align="center"><? echo $n;?></div></td>
    			         <td align="left"><div align="center">
							<? $sqlc = mysql_db_query("$dbname","SELECT reserve_day FROM reserve where reserve_day='$rowsqlb[reserve_day]'");
							$rowsqlc=mysql_fetch_array($sqlc);
							echo $rowsqlc[reserve_day];?></div></td>
	  		        <td align="right"><div align="left">
      		            	&nbsp;<? $sqlc = mysql_db_query("$dbname","SELECT FirstName ,LastName FROM customer where Customer_ID='$rowsqlb[0]'");
							$rowsqlc=mysql_fetch_array($sqlc);
							echo $rowsqlc[FirstName]."&nbsp;&nbsp;&nbsp;&nbsp;".$rowsqlc[LastName];?></div></td>
           	                <td align="right"><div align="center">
							<? $sqlc = mysql_db_query("$dbname","SELECT Seat FROM reserve where Seat='$rowsqlb[Seat]'");
							$rowsqlc=mysql_fetch_array($sqlc);
							echo $rowsqlc[Seat]; ?></div></td>
				<td align="right"><div align="center">
							<? $sqlc=mysql_db_query("$dbname","SELECT route_name FROM route, busroute where busroute.entrance=route.route_id='$rowsqlb[route_name]'");
							$rowsqlc=mysql_fetch_array($sqlc);
							echo $rowsqlc[route_name];?></div></td>
			 	<td align="right"><div align="center">
							<? $sqlc=mysql_db_query("$dbname","SELECT route_name FROM route, busroute where busroute.destination=route.route_id='$rowsqlb[route_name]'");
							$rowsqlc=mysql_fetch_array($sqlc);
							echo $rowsqlc[route_name]; ?></div></td>
			   	<td align="right"><div align="center">
							<?=$rowsql[0];?> .-</div>
	  			</tr>
  <? }?>
  				<tr bgcolor="DDDDDD" height="25">
            	 <td>&nbsp;</td>
				<td>&nbsp;</td>
				<td>&nbsp;</td>
				<td>&nbsp;</td>
				             <td colspan="2"><div align="center"><strong>รวมยอดการจองทั้งสิ้น</strong></div></td>
				<td><div align="center"><strong><font color="#FF0000">
		    				<?=$rowsql[0];?>
                                <font color="#000000">บาท</font></font></strong></div></td>
      		 </tr>
</table>