pre-fill form help

[nightrain]

I have a basic form that sends user preferences to a database.  I'd like to make it so that when the user revisits the page, the form is pre-filled with their preferences.

 

lets say the form looks like this:

<form action="index.php" method="post">
<select name="color">
                <option value="" selected>select one</option>
                <option value="red">Red</option>
                <option value="blue">Blue</option>
        </select>

        <input name="submit" type="image" value="submit">
</form>

 

other necessary info:

 

hostname = localhost

username = username

password = password

database name = database

table name = table

primary key = user

colors row = color

 

given the above, can anyone help me with a sample script that will prefill the color field using the database?

 

thanks for your help!

[perezf]

Try storing the information in cookies

[nightrain]

thanks but can you give me an example?

 

is that as reliable as using the database?

[nightrain]

anyone?