$sql = "SELECT name FROM pname order by name";
$result = $conn->query($sql);
while($row = $result->fetch_array()) {
echo "<option value='".$row[0]."'>".$row[0]."</option>";
}
$sql = "SELECT name FROM pname order by name";
$result = $conn->query($sql);
while($row = $result->fetch_array()) {
echo "<option value='".$row[0]."'>".$row[0]."</option>";
} // while