[RESOLVED] Select HTML statement with SQL data

dcjones

Hi all,

Not to sure if this is the right area to place this post.

I have a SELECT field on a page which has 4 options from a static list.

When an option is selected and the update button clicked the selection is written to the SQL table.

My problem is that when the same form is opened again, maybe to up date another field, the select field displays the first option in the list. If the up date button is clicked the data is written to the SQL table.

How can I make the SELECT field display the data in the SQL table rather then the first option in the static list.

The SELECT code I am using is simple:

+++++++++++++++++++++++++++++++++++++
<select class="bodytext" name="question2" id="question2">
<option value="Father's first name">Father's first name</option>
<option value="Mother's maiden name">Mother's maiden name</option>
<option value="Town/City of birth">Town/City of birth</option>
<option value="Name of your first school">Name of your first school</option>
</select>
+++++++++++++++++++++++++++++++++++++

Can anyone please advise me.

bradgrafelman

Is the dropdown's HTML generated dynamically or statically? If statically, then you'd have to do something like:

?>
<select class="bodytext" name="question2" id="question2">
<option value="Father's first name" <?php if($result['question2'] == 'Father\'s first name') echo 'selected="selected"'; ?>>Father's first name</option>

and so on.

dcjones

Hi and many thanks for your reply.

I have tried t use the code but with errors. I have played around with it but so far no luck.

Can you advise, please

bradgrafelman

Show us the code you've tried and we can try to help you.

dcjones

I have resolvd the problem with help from you. You gave my brain a jump start. This is the code I am now using with 100% results. As you will see from the code I am using the Smarty Template engine, hence the odd code statement.

<select name="question1" size="1" class="bodytext" id="question1"> <option value="Father's first name" {if $user.question1 eq 'Fathers first name'}selected="selected"{/if}>Father's first name</option> <option value="Mother's maiden name" {if $user.question1 eq 'Mothers maiden name'}selected="selected"{/if}>Mother's maiden name</option> <option value="Town/City of birth" {if $user.question1 eq 'Town/City of birth'}selected="selected"{/if}>Town/City of birth</option> <option value="Name of your first school" {if $user.question1 eq 'Name of your first school'}selected="selected"{/if}>Name of your first school</option> </select>

Many thanks for your help

bradgrafelman

Don't forget to mark this thread resolved.