<option value="">Select Heads</option> <?php $q=$_GET["q"]; include('config.php'); $hotels = $js->prepare('SELECT * FROM `hotelreservations` WHERE custid = :q '); $hotels->execute(array(':q' => $q)); $hotelcount = $hotels->rowCount(); if($hotelcount > '0') { echo "<option value='Hotel'>Hotel</option>"; } $hotels = $js->prepare('SELECT * FROM `travelassistance` WHERE custid = :q '); $hotels->execute(array(':q' => $q)); $hotelcount = $hotels->rowCount(); if($hotelcount > '0') { echo "<option value='Transportation'>Transportation</option>"; } $hotels = $js->prepare('SELECT * FROM `otherservices` WHERE custid = :q '); $hotels->execute(array(':q' => $q)); $hotelcount = $hotels->rowCount(); if($hotelcount > '0') { echo "<option value='Other Services'>Other Services</option>"; } ?>