<option>SELECT GOVERNATE</option> <?php $q=$_GET["q"]; include("example.php"); $con = mysql_connect("p3nlmysql57plsk.secureserver.net:3306","hpdb","hpdb123!@#"); //$con = mysql_connect("localhost","root",""); if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("hpdb", $con); $sql="SELECT * FROM governates where country= '$q' ORDER BY gname"; $result = mysql_query($sql); while($row = mysql_fetch_array($result)) { $gid = $row['id']; $gname = strtoupper($row['gname']); echo "<option value='$gid'>$gname</option>"; } mysql_close($con); ?>