<option>SELECT LOCATION</option> <?php $q=$_GET["q"]; 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 location where governate = '$q' ORDER BY locname"; $result = mysql_query($sql); while($row = mysql_fetch_array($result)) { $lid = $row['id']; $lname = strtoupper($row['locname']); echo "<option value='$lid'>$lname</option>"; } mysql_close($con); ?>