How to load mysql data on option html form

Question

I have this option form:

<tr>
<td><font size="3">Civil Status</td>
<td>:</td>
<td>
    <select name="cs" id="cs">
        <option>Single</option>
        <option>Married</option>
        <option>Widowed</option>

    </select></td></td>

What do I do in order to load it with mysql data, like this one:

<td width="23"><font size="3">Sex</td>
<td width="3">:</td>
<td width="174"><input name="sex" type="text"  maxlength="1" value="<?php echo $row["SEX"]; ?>"></td>

Your HTML is not well formed, and we need the MySQL table layout, plus what information your reading from what table. Also, how do you want the form to be submitted? GET or POST? — Mark Tomlin
– Mark Tomlin, Commented Feb 27, 2010 at 7:49

Adrian Schmidt · Accepted Answer · 2010-02-27 07:49:17Z

2

$result = mysql_query(blahblah);

<select name="cs" id="cs">
    <?php
    while ($line = mysql_fetch_array($result)) {
        echo '<option value="' . $line['id'] . '">' . $line['name'] . '</option>';
    }
    ?>
</select>

Something like that should do it. If I understood the question correctly...

answered Feb 27, 2010 at 7:49

Adrian Schmidt

1,88522 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to load mysql data on option html form

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related