MYSQL retrieve data

simwiz

hi, Hopefully there will be a simple answer to this!

Basically ive been able to retrieve data from a data base so user may be able to edit their details, the problem is ! Im unable to call the values back into my drop down menu form objects! The script works but data will only be outputted into the textfield objects

snippets of code, which is relevant

while($row = mysql_fetch_array($result, MYSQL_ASSOC))
{
$lname = $row['lastName'];
$fname = $row['firstName'];
$country = $row['country'];

}

output to form objects

A.) WORKS

<td align="right">First Name</td>
<td>
<input class="txtbox" type="text" name="lastName"value="<?php echo $fname ?>"size="40" maxlength="40">
</td>

B.) drop down menu

<td height="28" align=right>Country</td>
<td>
<select class="txtbox" name="opt_country"value="<?php echo $country ?>" size="1">
<option>England</option>
<option>US</option>
<option>Germany</option>
<option>france</option>
</select>

</td>

conclusion- can I get the drop down menu value to be the value saved within the db table.

thank you in advance

devinemke

$countries = array(
'England',
'US',
'Germany',
'France'
);

echo '<select name="opt_country">';
foreach ($countries as $value)
{
	echo '<option value="' . $value . '"';
	if ($value == $country) {echo ' selected';}
	echo '>' .$value  . '</option>';
}
echo '</select>';

simwiz

cheers ! il implement it later and tell you how i get on, thanks!

simwiz

Hi, the code works, well when i goto comfirm the edit the drop down value will change and be added to the db table.

But when i call the data back into the form objects the drop down still outputs the first value say ENGLAND even if the user registered with their country GERMANY for example.

$opt_country = $row['country'];

<?php
$country = array(
'England',
'US',
'Germany',
'France'
);

echo '<select name="opt_country">';
foreach ($country as $opt_country)
{
echo '<option value="'.$opt_country.'"';
if ($opt_country == $country) {echo ' selected';}
echo '>' .$opt_country. '</option>';
}
echo '</select>';

any ideas ? thanks!

devinemke

look at my example again. note the difference between the two variables $country and $countries

simwiz

I thought it may of been a typo, my mistake !

ive tried it again but $country is a undeclared variable, thanks for current help :p

Its ok now ive sorted it, thanks! il now implement it into my other drop downs 😃

thanks again

fasmy98

devinemke wrote:

$countries = array(
'England',
'US',
'Germany',
'France'
);

echo '<select name="opt_country">';
foreach ($countries as $value)
{
	echo '<option value="' . $value . '"';
	if ($value == $country) {echo ' selected';}
	echo '>' .$value  . '</option>';
}
echo '</select>';

can i implement this for the drop down menu with database?