Select List/Menu using PHP

[Xman117]

Here is my code:
<select name="country" class="sidelinks">
<?php
do
{
?>
<option value="<?php echo $row_AllCountries['country_ID']." ";?>"<?php if ($row_AllCountries['country_ID'] == $acountry) { echo "selected"; }?> >
<?php echo $row_AllCountries['countryname'];?></option>
<?php
}
while ($row_AllCountries = mysql_fetch_assoc($AllCountries));
?>
</select>

A few words to describe:
-$row_AllCountries['country_ID'](get from MySQL) is a unique country ID number
-$row_AllCountries['countryname'](get from MySQL) is the name of the country
-$acountry is the country ID number that i want to be selected when the form loads

I have a MySQL database where there are stored country names and their serial numbers(unique for each country).
I have a page with a form and there is a List Box(menu) with this countries in it.
When the page starts I want a specific country to be selected and that country ID to be equal to $acountries.
Anyone knows where's the problem and how to solve it???

Thanks and best regards
Rok

[Oleg Butuzov]

just a fix

Code: Select all

<?php if ($row_AllCountries['country_ID'] == $acountry) { echo " selected "; }?>

seems that you dont have a space where it must be...

[Xman117]

Code: Select all

<option value="<?php echo $row_AllCountries['country_ID'];?>"<?php if ($row_AllCountries['country_ID'] == $acountry) { echo " selected"; } ?> >                                   
         <?php echo $row_AllCountries['countryname'];?></option>

I was trying to solve it quite a time )

Thnaks!!! :-?

BR
Rok