Arrays etc

[trooper]

Hi I'm difficulty with arrays

My problem is as follows

I have a table that i pull two values from
(id and name_en)

what i want to do is put the value and the id into an array.

e.g 1 London
2 Paris etc

I can quite easily pull from the table and put one of the fields into an array

e.g
while($row = mysql_fetch_array($result))
{
$location[] =$row["name_en"];
}

but what i want to know is how do i also pull the id of the name_en into the array

I want to build a drop down menu using the values in the location array and have the id as the value ?

Anyone got any good help?

TIA

[amcgrath]

here ya go:

while($row = mysql_fetch_array($result))
{
$location[$row["id"]] = $row["name_en"];
}

now you have a array with the id as the key, and the name as the value.....

[trooper]

Cheers Allen

Just one question (dumb that it is)

How do i then list and access the elements?

[[deleted]]

while($row = mysql_fetch_array($result))
{
$id[]=$row["id"];
$location[] =$row["name_en"];
}

print "<select name=id>";
for($i=0; $i<sizeof($id); $i++){
print "<option value=$id[$i]>$location[$i]";
print "</option>"
}
print "</select>";

is that what are you asking for!?!

[trooper]

Peio

It is but i want the id to be automatically associated with the name_en.

that way if i shuffle or do anything else to the array the id and name_en values will still be connected

[[deleted]]

use Allen's sugestion then and combine it with
usort() function to shuffle the array, because
when you use shuffle() the key=>value connection is lost

[amcgrath]

Not sure what u mean, the code i posted lists and gives access to them. let me know in more detail what yuo want.