<?php $q=$_GET["q"]; $x = $_GET['x']; ?> <option>SELECT HOTEL</option> <?php include('config.php'); $result = $js->prepare('SELECT * FROM `hotelvendor` where category = :q AND governate = :x ORDER BY hotelname'); $result->execute(array(':x' => $x, ':q' => $q)); while($row = $result->fetch(PDO::FETCH_ASSOC)) { $hid = $row['id']; $location = $row['location']; $hotelname = strtoupper($row['hotelname']); echo "<option value='$hid'>$location - $hotelname</option>"; } ?>