key value pairs

Tiger99

Hi
I am just wondering is there a way to store my database values from user_id column and user_name column as a key - value pair.
So, I can print the user_id by knowing user_name

please help

Thanks in advance

tomhath

It sounds like you already have what you need:

select user_id, user_name
from myTable
where user_name = 'Tiger99'

Tiger99

what I am trying to achieve is to create a dropdown menu to display all the names. Then as a name is selected, its corresponding id is known.
I am thinking about using foreach() funcation and key=>value property. But I am not sure how it works

Please help

Thanks in advance

tomhath

This article covers most of what you are trying to do. You might still need a foreach loop to build the options list, but a little time reading the docs should get you there, and you'll probably learn a bunch of other useful stuff on the way:

http://www.phpbuilder.com/columns/tim19991124.php3

br__ken

minus the syntax errors (i freewrote it in here) this should pull all users, put them in an array like User=>Id, then print them out to a select box with the value = id, and text = username

i used array_unique too because it will only print unique usernames (if thats an issue)

$users=array();
$result=mysql_query("SELECT * FROM users ORDER BY username ASC");
while($data=mysql_fetch_array($result))
 $users[$data['username']]=$data['id'];

echo "<select name='user'>";
foreach(array_unique($users) as $k=>$v)
 echo "<option value=$v>$k";
echo "</select>";

im not sure if thats what u meant, but its what i got from the ?