php mysql option box question

[Desbrina]

I have an option box that i have several options in. What i want to do is be able to have it select the one that is in the database.

So the options are

Now, Later, Before

and in the database the field is called time

I want it to be automatically selecting the correct one, how do i go about this?
_________________
Midnight Tempest - A Sailor Moon TCG
Balanced Force - A Star Wars TCG

[krt]

Loop over the options and add selected attribute to the appropriate one. Assuming interspersed HTML:

[Desbrina]

thanks, works perfectly
_________________
Midnight Tempest - A Sailor Moon TCG
Balanced Force - A Star Wars TCG