<option>SELECT HOTEL</option> <?php $q=$_GET["q"]; $x = $_GET['x']; include("example.php"); $con = mysql_connect("50.62.209.50:3306","hpdb","hpdb123!@#"); //$con = mysql_connect("localhost","root",""); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("hpdb", $con); $sql="SELECT * FROM hotelvendor where country = '$x' AND governate = '$q' ORDER BY hotelname"; $result = mysql_query($sql); while($row = mysql_fetch_array($result)) { $hid = $row['id']; $location = $row['location']; $hotelname = strtoupper($row['hotelname']); echo "<option value='$hid'>$location - $hotelname</option>"; } mysql_close($con); ?>