[SOLVED] Populating drop down box from database

[ashrobbins87]

I'm getting very frustrated with this, I've searched all over for a solution for this, with differing responses. I want a list of names from a database to populate a drop down list. The code I have at the moment is....

 

$getUsers_sql ="SELECT id, firstname FROM cms_users";

$getUsers_res = mysqli_query($mysqli, $getUsers_sql)or die(mysqli_error());

$getUsers_sql ="SELECT id, firstname FROM cms_users";
$getUsers_res = mysqli_query($mysqli, $getUsers_sql)or die(mysqli_error()); 

echo '<select name="users">'; 
while ($row = mysqli_fetch_assoc($result)) 
{ 
    echo '<option value="' . $row['id'] . '">' . $row['firstname'] . '</option>'; 
} 
echo '</select>';

 

 

 

[Maq]

Change this line:

 

while ($row = mysqli_fetch_assoc($getUsers_res)) 

[Silverado_NL]

well u havent stated anything wrong, but im guessing its got to do with where you are refering to the mysql source.

$getUsers_res is used to set resource.

but in the while loop your using $result.

[Silverado_NL]

meh to late

[ashrobbins87]

Thanks guys, cant believe I couldn't see that!