need help

[salhzmzm]

hi

 

in my page there is this code:

 

<select name="select_one" onchang="form1.submit()">
<option value="select">please select</option>
<?php
$row=mysql_query("select * from mytable order by id");
while ($rows=mysql_fetch_array($row)) {
echo "<option value=$rows[id]>$rows[product]</option>;
}
?>

 

when the user is select the page submits and every thing apear ok, but I want the option that user had select it be the selected.

I have problem the it the selected always the first option.

 

so please help me.

 

thanks.

[haku]

<select name="select_one" onchang="form1.submit()">
<option value="select">please select</option>
<?php
$row=mysql_query("select * from mytable order by id");
while ($rows=mysql_fetch_array($row)) {
echo "<option value=$rows[id]";
if($current_user_id == "$rows['id'])
{
    echo "selected=\"selected\"";
}
echo ">$rows[product]</option>;
}
?>

 

 

note: I didn't fix your syntax errors.

[salhzmzm]

thanks for you're help.