0

I have read tutorials about how to populate an entire Drop down list with MySQL, but the problem I am running into is that I only want to grab the one from the database and have that be the selected one. So I would have like a drop down with three items (Item1, Item2, Item3) in the database its stored in a column called itemschoice which has a value of 'Item2'. How do I go about getting item2 to be selected when I load the drop down box?

JosephD
  • 321
  • 1
  • 8
  • 12

1 Answers1

3

In your <option> element add the selected attribute for the value that is in itemschoice.

Crude example using a made up function to get the choice:

$choice = get_items_choice();
$results = mysqli_query($sql);

echo '<select name="whatever">';
while($row = mysqli_fetch_array($results)) {
    if ($row['choice'] === $choice) {
        echo '<option value="' . $choice . '" selected="selected" />';
    } else {
        echo '<option value="' . $choice . '" />';
    }
}
echo '</select>';

This is just an example, don't copy & paste this without adding some kind of error verification!

Charles Sprayberry
  • 7,741
  • 3
  • 41
  • 50
  • I thought of that but consider this `` If I replaced the Selected one with PHP code then Item2 would appear twice in the list. – JosephD Jul 17 '11 at 16:47
  • @JosephD See my edit adding the code example. You should be able to get your list with the specific one selected without adding duplicate entries. – Charles Sprayberry Jul 17 '11 at 16:52