6 replies to this topic

[Chris.]

how can i make a mysql loop and then echo it in a drop down menu? You know what I mean? like the drop down menu in the top left of P2L header, how can I do that, but with usernames, and now have to insert all them individually?

[jakevfr]

I'm not entirely sure I understand what you mean but I'd do something like this

<input type="select">
<?
while ($this = mysql_fetch_array($query) > 0)
{
echo "<option value=\"".$this[name]."\">".$this[name]
}
?>
</input>

I wouldn't just copy this because I haven't done something like this in a while

[Chris.]

i want a drop down menu that echos all the user names in the table 'users' without me having to add them individually.

[Demonslay]

Which is exactly what jake tried to give you, only he's not quite keen on his basic HTML apparently.

<select id="users">
<?php
$query = mysql_query("SELECT * FROM `users`") or die(mysql_error());
while ($users = mysql_fetch_array($query))
{
echo '<option value="'.$users['name'].'">'.$users['name'].'</option>';
}
?>
</select>

Simple as that.

Edited by Demonslay, 24 September 2006 - 08:24 PM.

[jakevfr]

You have to close <option>... Hmm... I've never had a problem with that, and I never do...

And for the input part of mine all I can say is oops I guess that's what I get for not using HTML in a while

[Chris.]

thanks, worked just fine!

[Demonslay]

The close option tag is optional, I just very XHTML picky.

Main thing you had though was the 'input' (don't know how you got that...) and you were missing a semicolon at the end of your echo command, which would throw an unexpected '}' error.