สอบถามการ แสดงข้อมูลจาก sql แบบคอลัมป์ โดยมีเงื่อนไขตามแถวที่กำหนด

                            <?php Include_once ("../pizzamobile/db/connectDatabase.php"); 

		 if ($buttonss6=="ค้นหา")
		{
				
				
		}else{
		
	if($_POST['date1']!=""){
	$date11=$_POST['date1'];}
	else{ $date11=date('Y-m-d');}
    $ye11=substr($date11, 0, 4);
    $mo11=substr($date11, 5, 2);
    $dd11=substr($date11, 8, 2);
	$dateser1=$ye11."-".$mo11."-01";
	$dateser2=$ye11."-".$mo11."-31";
	
		$rs="'RS'";
		$cc="'cancle'";
		
				  $strSQLxx99 = "SELECT booking.*, sfcar1.*, modelcar2.*, modelcar1.* FROM booking
				
				LEFT JOIN sfcar1 ON booking.sfcar1 = sfcar1.idsfcar1 
				LEFT JOIN  modelcar2 ON sfcar1.idmodelcar2 = modelcar2.idmodelcar2 
				LEFT JOIN  modelcar1 ON modelcar2.idmodelcar1 = modelcar1.idmodelcar1 
				where booking.marginkid11 between '$dateser1' and '$dateser2' and booking.statusbook =$rs order by modelcar1.idmodelcar1 asc , sfcar1.idsfcar1 asc ";

		$objQueryxx99 = mysql_query($strSQLxx99) or die ("Error Query [".$strSQLxx99."]");
		$num_rowsxx99 = mysql_num_rows($objQueryxx99);
		}
		
		
		?>
                            <?php while($objResultxx99 = mysql_fetch_array($objQueryxx99))
		{	
		
			if($objResultxx99["idmodelcar1"]=="M1001"){$camryQAAB1234++;		}
		else if($objResultxx99["idmodelcar1"]=="M1002"){$altisQAAB1234++;		}
		else if($objResultxx99["idmodelcar1"]=="M1003"){$viosQAAB1234++;		}
		else if($objResultxx99["idmodelcar1"]=="M1004"){$yarisQAAB1234++;		}
		else if($objResultxx99["idmodelcar1"]=="M1023"){$yarisaQAAB1234++;		}
		else if($objResultxx99["idmodelcar1"]=="M1021"){$sientaQAAB1234++;		}
		else if($objResultxx99["idmodelcar1"]=="M1005" or $objResultxx99["idmodelcar1"]=="M1006" or $objResultxx99["idmodelcar1"]=="M1007" or $objResultxx99["idmodelcar1"]=="M1022"){$orpcQAAB1234++;		}
		else if($objResultxx99["idmodelcar1"]=="M1008" or $objResultxx99["idmodelcar1"]=="M1009"){$bcQAAB1234++;	}	
		else if($objResultxx99["idmodelcar1"]=="M1010"){$cc42QAAB1234++;		}
		else if($objResultxx99["idmodelcar1"]=="M1011"){$cc24QAAB1234++;		}
		else if($objResultxx99["idmodelcar1"]=="M1012"){$cc44QAAB1234++;		}
		else if($objResultxx99["idmodelcar1"]=="M1013"){$dc42QAAB1234++;		}
		else if($objResultxx99["idmodelcar1"]=="M1014"){$dc24QAAB1234++;		}
		else if($objResultxx99["idmodelcar1"]=="M1015"){$dc44QAAB1234++;		}
		else if($objResultxx99["idmodelcar1"]=="M1016" or $objResultxx99["idmodelcar1"]=="M1017" or $objResultxx99["idmodelcar1"]=="M1019"){$forQAAB1234++;		}
		else if($objResultxx99["idmodelcar1"]=="M1018"){$hiaceQAAB1234++;		}
			
	
		
		
		
		
		}
	$kangQAA123434=$camryQAA1234+$altisQAA1234+$viosQAA1234+$yarisQAA1234+$yarisaQAA1234+$sientaQAA1234+$orpcQAA1234;
		$kangQAAB1234=$camryQAAB1234+$altisQAAB1234+$viosQAAB1234+$yarisQAAB1234+$yarisaQAAB1234+$sientaQAAB1234+$orpcQAAB1234;
		$kbQAA123434=$bcQAA1234+$cc42QAA1234+$cc24QAA1234+$cc44QAA1234+$dc42QAA1234+$dc24QAA1234+$dc44QAA1234+$bcQAAB1234+$cc42QAAB1234+$cc24QAAB1234+$cc44QAAB1234+$dc42QAAB1234+$dc24QAAB1234+$dc44QAAB1234;
		$for1234=$forQAA1234+$forQAAB1234;
		$hiace1234=$hiaceQAA123434+$hiaceQAAB1234;
		$orther1234=$ortherQAA123434+$ortherQAAB1234;
		$allQAA123434=$forQAA1234+$hiaceQAA123434+$ortherQAA123434+$kangQAA123434+$kbQAA123434;
		
		$allQAAB1234=$forQAAB1234+$hiaceQAAB1234+$ortherQAAB1234+$kangQAAB1234+$kbQAAB1234;
		$all1234=$allQAA123434+$allQAAB1234;
	?>
                            </b></p>
                            <table width="1000" border="1">
                              <tbody>
                                <tr>
                                  <td colspan="19" bgcolor="#F4CF35">ชำระครบ/RS
                                    <?php $ho2="'Deler'";
				$strSQL1214999 = "SELECT * FROM login where cat=$ho2 ";
				$objQuery1214999 = mysql_query($strSQL1214999) or die ("Error Query [".$strSQL1214999."]");
				$objResultxx991214999 = mysql_fetch_array($objQuery1214999);
				echo $objResultxx991214999['username'] ?></td>
                                </tr>
                                <tr>
                                  <td rowspan="2">ชำระครบ/RS</td>
                                  <td colspan="7" bgcolor="#6AF4DC">เก๋ง</td>
                                  <td colspan="7" bgcolor="#F39A9B">กระบะ</td>
                                  <td rowspan="2" bgcolor="#6AF4DC">Fortner</td>
                                  <td rowspan="2" bgcolor="#F39A9B">Hiage</td>
                                  <td rowspan="2" bgcolor="#6AF4DC">Orther</td>
                                  <td rowspan="2" bgcolor="#F3AD84">TTL</td>
                                </tr>
                                <tr>
                                  <td bgcolor="#6AF4DC">Camry</td>
                                  <td bgcolor="#6AF4DC">Corolla</td>
                                  <td bgcolor="#6AF4DC">Vios</td>
                                  <td bgcolor="#6AF4DC">Yaris</td>
                                  <td bgcolor="#6AF4DC">Sienta</td>
                                  <td bgcolor="#6AF4DC">Yaris ATIV</td>
                                  <td bgcolor="#6AF4DC">Orther-Pc</td>
                                  <td bgcolor="#F39A9B">RevoB</td>
                                  <td bgcolor="#F39A9B">RevoC 4x2</td>
                                  <td bgcolor="#F39A9B">RevoC 2x4</td>
                                  <td bgcolor="#F39A9B">RevoC 4x4</td>
                                  <td bgcolor="#F39A9B">RevoD 4x2</td>
                                  <td bgcolor="#F39A9B">RevoD 2x4</td>
                                  <td bgcolor="#F39A9B">RevoD 4x4</td>
                                </tr>
                                <tr>
                                  <td>ชำระครบ/RS</td>
                                  <td bgcolor="#A6A4A4"><input name="baookrsrs1" type="text" id="baookrsrs1" size="5" value="<?php echo $camryQAAB1234; ?>" readonly></td>
                                  <td bgcolor="#A6A4A4"><input name="baookrsrs2" type="text" id="baookrsrs2" size="5" value="<?php echo $altisQAAB1234; ?>" readonly></td>
                                  <td bgcolor="#A6A4A4"><input name="baookrsrs3" type="text" id="baookrsrs3" size="5" value="<?php echo $viosQAAB1234; ?>" readonly></td>
                                  <td bgcolor="#A6A4A4"><input name="baookrsrs4" type="text" id="baookrsrs4" size="5" value="<?php echo $yarisQAAB1234; ?>" readonly></td>
                                  <td bgcolor="#A6A4A4"><input name="baookrsrs5" type="text" id="baookrsrs5" size="5" value="<?php echo $sientaQAAB1234; ?>" readonly></td>
                                  <td bgcolor="#A6A4A4"><input name="baookrsrs6" type="text" id="baookrsrs6" value="<?php echo $yarisaQAAB1234; ?>" size="5" readonly></td>
                                  <td bgcolor="#A6A4A4"><input name="baookrsrs7" type="text" id="baookrsrs7" size="5" value="<?php echo $orpcQAAB1234; ?>" readonly></td>
                                  <td bgcolor="#A6A4A4"><input name="baookrsrs8" type="text" id="baookrsrs8" size="5" value="<?php echo $bcQAAB1234; ?>" readonly></td>
                                  <td bgcolor="#A6A4A4"><input name="baookrsrs9" type="text" id="baookrsrs9" size="5" value="<?php echo $cc42QAAB1234; ?>" readonly></td>
                                  <td bgcolor="#A6A4A4"><input name="baookrsrs10" type="text" id="baookrsrs10" size="5"  value="<?php echo $cc24QAAB1234; ?>" readonly></td>
                                  <td bgcolor="#A6A4A4"><input name="baookrsrs11" type="text" id="baookrsrs11" size="5" value="<?php echo $cc44QAAB1234; ?>" readonly></td>
                                  <td bgcolor="#A6A4A4"><input name="baookrsrs12" type="text" id="baookrsrs12" size="5" value="<?php echo $dc42QAAB1234; ?>" readonly></td>
                                  <td bgcolor="#A6A4A4"><input name="baookrsrs13" type="text" id="baookrsrs13" size="5" value="<?php echo $dc24QAAB1234; ?>" readonly></td>
                                  <td bgcolor="#A6A4A4"><input name="baookrsrs14" type="text" id="baookrsrs14" size="5" value="<?php echo $dc44QAAB1234; ?>" readonly></td>
                                  <td bgcolor="#A6A4A4"><input name="baookrsrs15" type="text" id="baookrsrs15" size="5"  value="<?php echo $forQAAB1234; ?>" readonly></td>
                                  <td bgcolor="#A6A4A4"><input name="baookrsrs16" type="text" id="baookrsrs16" size="5"  value="<?php echo $hiaceQAAB1234; ?>" readonly></td>
                                  <td bgcolor="#A6A4A4"><input name="baookrsrs17" type="text" id="baookrsrs17" size="5"  value="<?php echo $ortherQAAB1234; ?>" readonly></td>
                                  <td bgcolor="#F3AD84"><input name="baookrsrstt1" onFocus="sum()"  onBlur="sum()"   onKeyPress="return KeyNum_dot(this)" onKeyUp="sum()"  type="text" id="baookrsrstt1" size="5" ></td>
                                </tr>
                                <tr>
                                  <td bgcolor="#F3AD84">รวมแยกประเภท</td>
                                  <td colspan="7" bgcolor="#F3AD84"><input name="baookrsrstt3" type="text" id="baookrsrstt3" size="5" ></td>
                                  <td colspan="7" bgcolor="#F3AD84"><input name="baookrsrstt4" type="text" id="baookrsrstt4" size="5" ></td>
                                  <td bgcolor="#F3AD84"><input name="baookrsrs18" type="text" id="baookrsrs18" size="5" value="<?php echo $forQAAB1234; ?>" ></td>
                                  <td bgcolor="#F3AD84"><input name="baookrsrs19" type="text" id="baookrsrs19" size="5" value="<?php echo $hiaceQAAB1234; ?>" ></td>
                                  <td bgcolor="#F3AD84"><input name="baookrsrs20" type="text" id="baookrsrs20" size="5" value="<?php echo $ortherQAAB1234; ?>" ></td>
                                  <td bgcolor="#F3AD84"><input name="baookrsrstt2" type="text" id="baookrsrstt2" size="5" ></td>
                                </tr>
                              </tbody>
                            </table>