[RESOLVED] drop down menu help

[tbales]

could some one help me with creating a drop down menu to show a list of results through one query

like i want to show

$result=mysql_query("SELECT `username` FROM `grpgusers` WHERE `id` = '".$user_class->id."'");

[djjjozsi]

As you can see, you have to use the groupusers_id to take into dropdown as value,

$result=mysql_query("SELECT `username`,`grpgusers_id` FROM `grpgusers` WHERE `id` =". (int)$user_class->id );

print "<select name=\"$var\">";
print "<option value=\"0\" DISABLED>SELECT A USER</option>";

while( $row = mysql_fetch_assoc( result ))
{
print "<option value=\"".$row["grpgusers_id"]."\">". htmlspecialchars(stripslashes($row["username"])) ."</option>\r";
}
print "</select>";

[tbales]

that code didnt work 🙁

[bradgrafelman]

That's most likely because 'grpgusers_id' should be simply 'id' in the code snippet above. But then again, you should never copy-and-paste code snippets but rather dissect them to understand the proposed solution to your problem (which you would then solve yourself, writing the applicable code)...

Also, you might want to ask why stripslashes() was applied to data coming from the DB; normally this should never need to be done...

[tbales]

i did just copy and paste how ever i edited the code where i pasted it but now i managed to get it to work and now im trying to get it into a input type here is the entire code below im trying to turn into a input type

<?
include 'header.php';
$gang_class = new Gang($user_class->gang);

if ($gang_class->leader != $user_class->username){
	echo Message("You do not have authorization to be here.");
	include 'footer.php';
	die();
}

if($_POST['changerole'] != "");
       $result=mysql_query("UPDATE `grpgusers` SET `gangrole` = '".$_POST['role']."' WHERE `username`= '".$_POST['username']."'");


?>
<tr><td class="contenthead">ROLE MANAGER</td></tr>
<tr><td class="contentcontent">
<form method='post'>
<?
$result=mysql_query("SELECT `username`,`id` FROM `grpgusers` WHERE `gang` ='".$gang_class->id."'"); 

print "<select name=\"$var\">"; 
print "<option value=\"0\" DISABLED>SELECT A USER</option>"; 

while($row=mysql_fetch_assoc($result)) 
{ 
print "<option name='username' value=\"".$row["id"]."\">". htmlspecialchars(stripslashes($row["username"])) ."</option>\r"; 
} 
print "</select>";
?>
<input type='text' name='role' size='10' maxlength='20'>ROLE<br />
<input type='submit' name='changerole' value='Change Role'>
</form>
</td></tr>
<?
include 'footer.php';
?>

[djjjozsi]

okay 🙂

but one thing, this is not valid:
(do not use name parameter in dropdowns...just only in the select tag)

print "<option name='username' value=\"".$row["id"]."\">". 

htmlspecialchars(stripslashes($row["username"])) ."</option>\r"; 

this is the format how you build a value->option pair for a dropdown:

print "<option value=\"".$row["id"]."\">". htmlspecialchars(stripslashes($row["username"])) ."</option>\r"; 

[tbales]

yes i figured that out when it said error so i put is back the way it was