select box query and current value

[vbthanks]

Hi all,
I want to echo the current db value in a html select box, and show other selections from another table also, so the admin can change the value if required.
I have 2 tables - one contains all the client data, the other contains the areas.
CLIENT TABLE:
----------------------
|clientID|client|area|
----------------------
| 39|swaugh| nth|
| 40|billyg| sth|
----------------------
AREAS TABLE:
-----------------
| areaID| area|
-----------------
| 1| nth|
| 2| sth|
| 3| wst|
| 4| est|
-----------------
The code below will echo all the area values to the select box, but I want to echo the current value from the CLIENT table into the select box AND all the values from the AREAS table as well.

<select name="area">
<?
$sql=mysql_query("SELECT * FROM areas");
while ($row = mysql_fetch_object($sql)) { 
echo  "<option value= \" $row->area\">$row->area</option>" ;
}
?>                   
</select>

Any help or direction appreciated!
Mike

[redux]

assuming that your current value is stored in $currentrow->area, modify your output like so

echo  "<option value= \"$row->area;
if ($row->area == $currentrow->area) {
    echo ' selected';
}
echo "\">$row->area</option>" ; 

that should work (it also keeps the currently selected option in the right order inside the select...

[edit]
and, if you want to be xhtml compliant, change the above code to

echo  "<option value= \"$row->area;
if ($row->area == $currentrow->area) {
    echo ' selected="selected"'; // no attribute minimisation
}
echo "\">$row->area</option>" ; 

[Mike]

Or even:

echo '<option value="' . $row->area . '"';
if ($row->area == $currentrow->area) {
    echo ' selected="selected"'; // no attribute minimisation
}
echo '>' . $row->area . '</option>'; 

[redux]

doh !

ok...i'll stick to the "design your site" section from now on then

[Mike]

Nah, we need you here

[vbthanks]

Thanks for the replies Have a problem though...

The select box is still only displaying all the area values and not the current value, which i have assigned. (I think!) This is what i've got...

$query = "SELECT * FROM $table WHERE clientID = $clientID";
$query_result_handle = mysql_query($query) or die(mysql_error());
$row = mysql_fetch_array($query_result_handle);
    $clientID = $row["clientID"];
    $clientName = $row["clientName"];
    $currentrow = $row["area"];
    
........

<TR><TD>Client Name:</TD>
<TD><input type="text" name="clientName" size="40" maxlength="50" value="<? echo $clientName; ?>">
</TD></TR>

<TD><select name="area">
<?
$sql=mysql_query("SELECT * FROM areas");
while ($row = mysql_fetch_object($sql)) { 
echo '<option value="' . $row->area . '"';
if ($row->area == $currentrow->area) {
    echo ' selected="selected"';
}
echo '>' . $row->area . '</option>';
}
?>                   
</select>
</TD></TR>

What am I missing?
Mike

[Mike]

Change it to this (I think)

<?
$area_query = mysql_query("SELECT area FROM areas");
while ($areas = mysql_fetch_array($area_query)) { 
echo '<option value="' . $areas["area"] . '"';
if ($areas["area"] == $currentrow) {
    echo ' selected="selected"';
}
echo '>' . $areas["area"] . '</option>';
}
?>

.

[Mike]

<edit>

[vbthanks]

Hey naramation - I played hockey with a guy from Penticton... I digress!
Still not working, just displaying all the values from the areas table, and not the current value from the client table as the selected option.
edit
I just echoed $currentrow and it displayed 'Object', so I assigned $currentrow incorrectly - fixed now!
Thankyou naramation and redux!
Mike

[Mike]

[Mike]

You could put it back to the object way aswell:

<?
$area_query = mysql_query("SELECT area FROM areas");
while ($areas = mysql_fetch_object($area_query)) { 
echo '<option value="' . $areas->area . '"';
if ($areas->area == $currentrow) {
    echo ' selected="selected"';
}
echo '>' . $areas->area . '</option>';
}
?>