hi,

i was wondering if anybody can help me?

i have a country table that holds 5 different countries. a dropdown list in my form is populated based on this table. the problem is i want the country stored in the member table to be the default selected in the list. this is the code i tried:

<select name=CountryFrm>
<?php
$qry = "SELECT CountryName FROM Country ORDER BY CountryName";

$result = mysql_query($qry);
while($row = mysql_fetch_assoc($result))
{
$CountryNameFrm = $row['CountryName'];

echo '<option value="'.$row[CountryName].'" selected>'.$row[CountryName].'</option>';
}
?>
</select>

Can anybody help

Thanks in Advanced

Scoobie

try replacing this line

echo '<option value="'.$row[CountryName].'" selected>'.$row[CountryName].'</option>';

to

echo '<option value="'.$row['CountryName'].'" selected>'.$row['CountryName'].'</option>';


Best Regard:
Md. Zakir Hossain (Raju)
www.rubd.net
www.xenex.rubd.net
www.forum.rubd.net

tried that. it didn't work it still displays the last item in the list

The "selected" keyword in the <option> HTML tag controls which value is selected in the drop-down list.

What's missing from your code is a test against your member record for each country to see if that's the one the member has chosen. The one that matches your member record should have the "selected" keyword and the other <option> tags shouldn't.

Bruce Luckcuck
Director, Applications & Support Services
Wiley Publishing, Inc.