无法从数据库填充列表

Question

I am trying to retreive data from a database and populate a list from it, there doesnt seem to be errors in my code and still the list is not populating, my code

<?php 
 $hostname = "localhost";
 $username = "username";
 $password = "password";
 $dbase = "db";
 $link = @ mysql_connect($hostname, $username, $password);
 $db_selected = @ mysql_select_db($dbase);
 ?>


<?php 
    include("scripts/dbconnect.php"); 
    $query="select class from school";
    $result=mysql_query($query);
    $numrows=mysql_num_rows($result);
    while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){
     echo '<option value="'.$row['class'].'">'.$row['class'].'</option>';
    }  
   ?> 

any help much appreciated, thanks

Answer 1

Options must be wrapped with select tag:

 echo "<select name='class'>";
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){
 echo '<option value="'.$row['class'].'">'.$row['class'].'</option>';
}  
 echo "</select>";

Additionally do:

if (!$link) {
    die('Could not connect: ' . mysql_error());
    break;
}

To see if there are any errors of mysql connection.