[TheCase]

Hello,

How can I create a drop down in that drop down I want it to include all the users on the table phpbb_user then define it as $dropdown so if i echo it

PHP Code:

echo "$dropdown"; 

It should each me back with the username selected. I really wan't to put $dropdown in a query to send the username to the db but if I echo it, this will tell me if it works.

Thanks

[Crassius]

Not sure what exactly you want, but if you want it to be a select box in a form then do:

PHP Code:

$query: mysql_query("select username, id from phpbb_user table");

$dropdown .= "<select name=something><option value="">&nbsp;</option>";

while($bob = mysql_fetch_array($query)){

   $dropdown.= "<option value=$bob[id]>$bob[username]</option>";

}

$dropdown.= "</select>";



//wherever you want to place the drop down list.

echo $dropdown; 

You can then use the id post value to do whatever you want with that individual's data.

[Shaffer]

Seems right, but are you sure you can access your PHPBB database?

[TheCase]

Yeah. Thank you