Populating a Select Element with MySQL Data

Question

I'm trying to populate a select element with firstname and lastname values from a MySQL database.

At this point I have the code bringing back the data and inserting only one row into the select element and then displaying the remaining data below the select element.

I'm not sure why this is not inserting all of the data into an option tag - any and all help is appreciated, I read similar questions and could not figure this out.

(Correct Method to Populate a Select Element with MySQL data, as corrected by @FGraviton)

mysql_select_db("dustin",$con);
$sql="SELECT id,lastname,firstname FROM drivers_0135199";
$result=mysql_query($sql,$con);

echo "<select name='currentdrivers' id='currentdrivers'>";
while($row=mysql_fetch_array($result)){
echo "<option value=\"".$row['id']."\">".$row['lastname'].",".$row['firstname']."</option>\n";
}
echo "</select>";

amrfaissal · Accepted Answer · 2011-12-07 05:18:39Z

3

You have to put </select> outside the while loop.

answered Dec 7, 2011 at 5:18

amrfaissal

1,0701 gold badge7 silver badges18 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Dustin James Over a year ago

Oh man, thanks @FGraviton, I was going cross eyed looking at this thing. It works!

Collectives™ on Stack Overflow

Populating a Select Element with MySQL Data

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related