The <select> tag doesn't support a value option

[dkate777]

I have a PHP/mySQL database running, and I've realized I'm come across an awkward little bug.

I have a form where a user fills out their information using populated drop down boxes. This information gets stored in the database. Then, if a user wants to edit their information later, they can go to the Edit Details page which calls up a page almost identical to the original form when they first set themselves up. Of course, the person's information is pulled from the database, and is echoed as the values of the form elements.

My issue is that the drop down boxes do not echo the value They are updated in the database correctly, but the drop downs don't know how to select the appropriate values.

The <select> tag doesn't support a value option, and I can't hardcode the selected="selected" into any specific <option> tag because the input from the database needs to determine which one that is.

Any suggestions anyone has would be greatly appreciated. Thanks!

[sumaabey]

Try this

<?
$sql="select name from table name";
execute the query
$row=mysql_fetch_array($res);
?>
<select>
<option value="<?=$row['name']?>" selected></option>
</select>

[nathj]

Try this
<?
$sql="select name from table name";
execute the query
$row=mysql_fetch_array($res);
?>
<select>
<option value="<?=$row['name']?>" selected></option>
</select>

Alternatively you can use selected="selected" in the option tag of the select element. This works just fine.

So as you build up the select using your database you can add this line to the item that is stored against the user.

Cheers
nathj

[pbmods]

Heya, dkate.

foreach($dbresults as $row => $data)
    echo "<option value=\"{$data['rowid']}\"" . (($data['rowid'] === $selectedValue)
        ? ' selected="selected"'
        : ''
    ) . ">{$data['rowname']}</option>\n";
 

If that is not an option, you could add some JavaScript somewhere after you create the SELECT element that runs through the options for your SELECT and sets the selected property to true if its value matches.

[dkate777]

Thanks All

I run the test and i see it's selected the right value, but still not display it.
Is anybody know why it's display?

[pbmods]

Heya dkate.

I run the test and i see it's selected the right value, but still not display it.
Is anybody know why it's display?

Please elaborate. What do you mean by 'selected the right value', and 'still not display it'?

[Motoma]

Thanks All

I run the test and i see it's selected the right value, but still not display it.
Is anybody know why it's display?

Perhaps you could post the relevant code?

[dkate777]

OK, I know where is my problem is.
I use jave script to display value on this form from other form
document.form.fieldname.value=firstformValue

i can display this value on textbox, but not on select box. I think it's possible, but i don't know how to do this.
Is anybody know how to pass value the right way

[Purple]

Hi dkate777,

you need to build the select statement with all of the options as you do on the initial form and append selected="selected"

take a look at the following function:

[PHP]//*
//* function - displays the job cost codes
//*
function job_cost_cat_select($data)
{
$code_select = "<tr><td>Cost type :</td><td><select name=\"jcexp_code\">
<option value=\"0\" selected=\"selected\">Not selected</option>";
$rows = 0;
$count = count($data);
while($rows < $count)
{
if(isset($data[$rows][0])) $code_select = $code_select . "<option value=\"" .
rtrim($data[$rows][0]) . "\">" . rtrim($data[$rows][1]) . "</option>";
$rows++;
}
$code_select = $code_select . "</select></td></tr>";
if (isset($_POST['jcexp_code']))
{
$code_select = str_replace("<option value=\"".$_POST['jcexp_code']."\">",
"<option value=\"".$_POST['jcexp_code']."\" selected=\"selected\">",$code_select);
$code_select = str_replace("<option value=\"0\" selected=\"selected\">",
"<option value=\"0\">",$code_select);
}

return($code_select);
}[/PHP]

Hope this helps

Regards Purple