[RESOLVED] Returning only 1 row

[twilliamsen]

Everything looks ok to me, and I only get one row in a list box.

Here is the db side of the script:

<?php
$connection = @mysql_connect("localhost", "root") or die("Could not Connect to Database Server");
$db = @mysql_select_db("move_db", $connection) or die("Could Not Select Database");
$sql = "SELECT ID, FirstName, LastName FROM managers ORDER BY LastName";
$result = @mysql_query($sql, $connection) or die("Could Not Execute Query");
    while ($row = mysql_fetch_array($result)) {
        $id = $row['ID'];
        $fname = $row['FirstName'];
        $lname = $row['LastName'];

}
?>

Here is the listbox code:

<? echo "<select name=\"id\" >
		<option >- Please Specify a Manager -</option>
			 <option value= \"$id\"> $lname, $fname</option>  

                </select> 
				" ;
				?>

[void_function]

Yes, the code is supposed to return one row. Unless you wanted this:

$connection = @mysql_connect("localhost", "root") or die("Could not Connect to Database Server");
$db = @mysql_select_db("move_db", $connection) or die("Could Not Select Database");
$sql = "SELECT ID, FirstName, LastName FROM managers ORDER BY LastName";
$result = @mysql_query($sql, $connection) or die("Could Not Execute Query");

echo '<select name="id"><option value="0">- Please Specify a Manager -</option>';
    while ($row = mysql_fetch_array($result)) {
        $id = $row['ID'];
        $fname = $row['FirstName'];
        $lname = $row['LastName'];
        echo "<option value= \"$id\"> $lname, $fname</option>\n";
    }

echo '</select>';

[twilliamsen]

so what caused this to return only 1 row? The static option I put in?

[void_function]

No, you did not echo <options> from within the loop, but after the loop where, naturally, $id, $fname and $lname contain the values from last iteration.

[twilliamsen]

well, that explains it. thanks!