Re: Option Value

On 2/23/07, Dan Shirah <mrsquash2@gmail.com> wrote:

On my form I have several drop down menus. They all work and display the corrent values. However, I would like the initial display of the form to show each dropdown as blank. $q_status = "SELECT * FROM status_codes ORDER BY status_description"; $r_status = mssql_query($q_status) or die(mssql_error()); while ($rec_status = mssql_fetch_assoc($r_status)) $status[] = $rec_status; foreach ($status as $s) { if ($s['status_code'] == $_POST['status'])

     echo "<OPTION value=\"{$s['status_code']}\"

SELECTED>{$s['status_description']}</OPTION>\n"; else

     echo "<OPTION

value=\"{$s['status_code']}\">{$s['status_description']}</OPTION>\n"; } Any suggestions on how to make my initial display of the field blank without having to add a blank row to my table?

Meaning: you want the select box to show as a default value a blank line but have the remaining data items from the db still in the drop-down list? Then you want to use the "selected" attribute on a blank line. Plenty of examples available. David