Output PHP mySQL query into dropdown

Question

Been at this for a bit and I cannot figure out what is wrong. I am trying to output a mySQL query into a drop down (just using PHP). The dropdown works, but there are no values in the list. However, it does seem to be aware of how many rows are in the table. Please advise. Thanks!

<html>
<head>
<body>

<table border="1">


<?php
require_once ('includes/database.php');         

$query = "SELECT User_ID FROM User_Account";
$result = mysqli_query ($my_dbhandle, $query);
echo "<select name=dropdown value=''>Dropdown</option>";
while($r = mysqli_fetch_array($result)){
echo "<option value=" . $r['User_ID'] . ">" . $r['User_ID'] . "</option>";
}
echo "</select>";



mysqli_close($my_dbhandle);
?>

</table>
</body>
</head>
</html>

Plus, [your other question](http://stackoverflow.com/q/29451227/) already contains your solution for this. Just do the same for the option echo. — Funk Forty Niner, Apr 11 '15 at 16:38

score 2 · Accepted Answer · answered Apr 11 '15 at 16:34

2

You forgot to add the actual text. So this:

"<option value=$r[User_ID]></option>";

should be this:

"<option value=" . $r['User_ID'] . ">" . $r['User_ID'] . "</option>";

If User_ID is in any way editable by users, you also should add protection against XSS.

answered Apr 11 '15 at 16:34

tim

1,999
17
32

Thank you @tim. That was it. I will mark it correct ASAP. – Kripros Apr 11 '15 at 16:40

Output PHP mySQL query into dropdown

1 Answers1