<?php $sql="select * from master_equipment INNER JOIN booking_equipment_selection ON booking_equipment_selection.equipID = master_equipment.equipID where booking_equipment_selection.ticketID = '$ticketID' ORDER BY booking_equipment_selection.equipID"; $query901 = mysql_query($sql); while($objResult1 = mysql_fetch_array($query901)) { $equipID_check1 = $objResult1['equipID']; $name_equipment_check1 = $objResult1['name_equipment']; ?> <td> <select name="equip" id="equip" style="width:90px;" > <option value="000">Please Select</option> <?php if($name_equipment_check1 == 'Life Jacket') { $sql="select * from master_equipment where name_equipment='Life Jacket'"; $query902 = mysql_query($sql); while($resule = mysql_fetch_array($query902)) { $size_equiment = $resule['size']; $equipID_check2 = $resule['equipID']; //$name = $resule['name']; ?> <option value="<?php echo $equipID_check1;?>" <?php if($equipID_check1 == $equipID_check2) echo "selected" ?>><?php echo $size_equiment; ?></option> <?php } } ?> <?php if($name_equipment_check1 == 'Fins No') { $sql="select * from master_equipment where name_equipment='Fins No'"; $query902 = mysql_query($sql); while($resule = mysql_fetch_array($query902)) { $size_equiment = $resule['size']; $equipID_check2 = $resule['equipID']; //$name = $resule['name']; ?> <option value="<?php echo $equipID_check1;?>" <?php if($equipID_check1 == $equipID_check2) echo "selected" ?>><?php echo $size_equiment; ?></option> <?php } } ?> <?php if($name_equipment_check1 == 'Beach Walker') { $sql="select * from master_equipment where name_equipment='Beach Walker'"; $query902 = mysql_query($sql); while($resule = mysql_fetch_array($query902)) { $size_equiment = $resule['size']; $equipID_check2 = $resule['equipID']; //$name = $resule['name']; ?> <option value="<?php echo $equipID_check1;?>" <?php if($equipID_check1 == $equipID_check2) echo "selected" ?>><?php echo $size_equiment; ?></option> <?php } } ?> <?php if($name_equipment_check1 == 'Snorkeling') { $sql="select * from master_equipment where name_equipment='Snorkeling'"; $query902 = mysql_query($sql); while($resule = mysql_fetch_array($query902)) { $size_equiment = $resule['size']; $equipID_check2 = $resule['equipID']; //$name = $resule['name']; ?> <option value="<?php echo $equipID_check1;?>" <?php if($equipID_check1 == $equipID_check2) echo "selected" ?>><?php echo $size_equiment; ?></option> <?php } } ?> </select>
<option value="<?php echo $equipID_check1;?>" <?php if($equipID_check1 == $equipID_check2) echo "selected" ?>><?php echo $size_equiment; ?></option>
<option value="<?php echo $equipID_check1;?>" <?php if($equipID_check1 == $equipID_check2) echo "selected" ?>><?php echo $name_equipment_check1; ?></option>
เพื่อความปลอดภัยของเว็บบอร์ด ไม่อนุญาติให้แทรก แท็ก [img]....[/img] โดยการอัพโหลดไฟล์รูปจากที่อื่น เช่นเว็บไซต์ ฟรีอัพโหลดต่าง ๆ อัพโหลดแทรกรูปภาพ ให้ใช้บริการอัพโหลดไฟล์ของไทยครีเอท และตัดรูปภาพให้พอดีกับสกรีน เพื่อความโหลดเร็วและไฟล์ไม่ถูกลบทิ้ง