[RESOLVED] Populating a drop down menu

mhodge87

Hey everyone,

I have table with about 20 columns in it. It has a lot of misc info, but I would like to take out a certain part and put it into a drop down box (specifically the firstn lastn and cid)

Here is my code:

//Query

$sql = "SELECT * FROM jos_roster";
$result = mysql_query($sql, $con) or die("There was an error with your query: $sql" . "<HR><BR>" . mysql_error());

//form

echo '<FORM name = "editroster" action = "editroster.php" method = "post">
      <Label> Controller </Label> <select name = "controllername">';

  //populates the drop down box
  while ($row = mysql_fetch_array($result))
  {
    $name = $row['cid'] . $row['lastn'] . $row['fname'];
    echo "<option value = " . $row['cid'] . ">";
    echo $name;
    echo "</option>";

  }
echo '</select>';
echo '</FORM>';

There isn't any errors with the code, however, it doesn't display anything in the drop down box. Thanks for any help.

cahva

Seem to me that there are no results to be shown and thats why select is empty. Use mysql_num_rows($result) after the query to see if there are rows.

BTW, use mysql_fetch_assoc() instead of mysql_fetch_array if you use field names in $row.

mhodge87

the num rows returns 4 which is the number of rows in the database, even fater changing to mysql_fetch_assoc, it still dosen't display anything

cahva

Debug a little. Use print_r($row) inside the while statement to see whats in the $row array.

mhodge87

I found out my problem, lol i wasn't calling the correct row. But now I have another question: How would I get the form to automatically reload once a new entry in the drop menu is selected:

Basically,

I have users in a drop down menu with multiple checkboxes in a form. I want to be able to select the user and it automatically populate the checkboxes depending on the entries in the database. I know how to populate the checkboxes, I'm just not sure how to have the form reload. Any ideas?

benracer

Using..

msnhockey

anyway to use the above to have alternating row colors in the drop menu