Populating a Drop down List with mySQL entries...I have one problem

[php-phan]

Ok so i figured out how to populate the drop down list with the list of Members on my website...that was simple. Now i want to know how do i set it to display the Users FIRST and LAST name but it will have a different value...

for example...when i choose the user "Sonny Trujillo" then the value will be its username...heres a better example

<select name="to" size="1">
	<option>Sonny Trujillo</option>
	<option>Joe Bob</option>
	<option>I think you get it</option>
</select>

the above code will be populated from mysql...so that just an example.

So i see the menu and then i go click on Sonny Trujillo.

I then click submit

echo $_GET['to'];

But when it prints out $_GET['to'] i want it to print out the USERNAME not SONNY TRUJILLO....urg does this make any sense...help... : (

[snb828]

<?php 
echo("<select name=\"to\" size=\"1\">");
$query = "SELECT * FROM `TABLE`";
$result = mysql_query($query);
$num_rows = mysql_numrows($result);

for($i=0; $i<$num_rows; $i++){
	$name  = mysql_result($result,$i,"Name");
	$username = mysql_result($result,$i,"Username");
	echo "<option value=\"".$username."\">".$name."</option>\r\n";
}
echo("</select>");
?>

[php-phan]

lol im so dumb i didnt know you can have a value element in the option tag lol...im dumb...thanks though!!!

[Kudose]

If this thread is resolved, please mark it so using the thread tools near the top of this thread.