drop down box

[slimjim]

How do i make it so that the category is showing that is listed in the database on top ?
The below list all of the categorys, and $categoryg is what that person has chosen already, I need it to show what that person already has chosen before he edits.

$sql="SELECT category FROM category ORDER by category ASC"; 
$result=mysql_query($sql); 

$options=""; 

while ($row=mysql_fetch_array($result)) { 

//$id=$row["id"]; 
$category=$row["category"]; 
$options.="<OPTION VALUE=\"$category\">".$category; 
} 
?> 
<SELECT NAME=categoryg> 
<OPTION VALUE=0>Choose 
<?=$options?> 
</SELECT> 

[rehfeld]

$category=$row["category"];
$selected = ($category == $_GET['category']) ? ' selected="selected"' : '';
$options.="<OPTION VALUE=\"$category\"$selected>".$category; 

[slimjim]

I did that and it keeps saying chose , instead of what category the person already has chosen.
It brings up on another part of the page the category he has chosen by echoing this $categoryg

if that helps.

[rehfeld]

you will need to replace
$_GET['category']

with whatever variable holds the value of the current category.

it sounds like you would want to use $categoryg

[slimjim]

Ok here is what I did, and it still is showing Choose

     $category=$row["category"]; 
     $selected = ($category == $_GET['$categoryg']) ? ' selected="selected"' : ''; 
     $options.="<OPTION VALUE=\"$category\"$selected>".$category;
} 
?> 
<SELECT NAME=categoryg> 
<OPTION VALUE=0>Choose 
<?=$options?> 
</SELECT> 

[Roger_Ramjet]

Loose the $ from the GET

$selected = ($category == $_GET['categoryg']) ? ' selected="selected"' : '';