displaying info in a submit form.

[LordRogaine]

I am creating a site where the members fill out a profile of themselves. The information goes into my database(mysql) with no problem. What I need to do is make it so that the members can call up their profile and change it when they want. I want them to be able to call up the form that inserts the data, but at the same time, I want the form to show them what they have already entered in the fields so that they can change only what they want without having to fill out the whole form again.

In a plain text box I'm able to do this with a query statement and by using <? echo "$information ?>.
When I try to do this with a muliple select box I can't seem to display the info that they have already inserted. How can I do this?

[archangel_617b]

For form input, you can provide default values or you can simply add a column with the current value:

<form action=script.php method=get>
<table align=center>

<tr valign=top><!-- Display current value separately -->
    <td>Username:</td>
    <td><?php print($name); ?></td>
    <td><input name=username type=text /></td>
</tr>

<tr valign=top><!-- Display current value as default -->
    <td>Homepage:</td>
    <td>&nbsp;</td>
    <td><input name=homepage type=text value="<?php print($homepage); ?>" /></td>
</tr>

<tr valign=top><!-- For a checkbox -->
    <td>Hobbies:</td>
    <td>&nbsp;</td>
    <td>
        <select name=hobbies size=3>
            <option value=tv<?php if ($tv) print(' selected'); ?>>Watching TV</option>
            <option value=php<?php if ($php) print(' selected'); ?>>Writing PHP</option>
            <option value=surf<?php if ($surf) print(' selected'); ?>>Surfing the Net</option>
        </select>
    </td>
</tr>

</table>
</form>

[LordRogaine]

Thankyou very much for the help