Need help to add values in list box

[rumon007]

I have created a list box writing a code as follows:

 

<select name=\"select_to_edit\">

<option selected>- -Select a Country- -</option>

</select>

 

And I have to variables named $id and $country_name.

 

Now I want to show the values of the $country_name variable in the List Box.

 

Please someone help me to write the code.

[lonewolf217]

where are you getting the values from ?  array ... database ... text file ?

 

details are always helpful

[Maq]

where are you getting the values from ?  array ... database ... text file ?

 

He did...

 

And I have to variables named $id and $country_name.

 

I'm guessing you want the option to be $country_name and the value that you reference the $id.  Try something like:

 

[prcollin]

while ($row = mysql_fetch_array($result)) {  
    echo "<option value="" . $row['id'] . "">" . $row['country_name] . "</option>

 

that is just for the drop down menu i am assuming you have the rest of the php code to pull the values from the database?

[rumon007]

both variables get all data from a database. for example -

 

$id      $country_name

---------------------------

1          USA

2          UK

3          India

4          Bangladesh

[Maq]

Then do what prcollin suggested:

 

echo "";
while ($row = mysql_fetch_array($result)) { 
    echo "{$row['country_name']}
}
echo "";