getting a select box to select a value

zerogreen

Lets start by giving the layout:

A guy fills in a form with personal details and such.
The form uses selectboxes and inputboxes and textareas.
The form submits and writes the data to a database.
Two months later the guy wants to change his info for some or other reason.

Now he goes and firstly logs in.
Then he goes to this new form to change his data.
The page does a query to get his previous info.

Now its easy enough to get the inputboxes to display the old values, but what I am looking for is a way to use the same selectboxes from the first form to display the old data as " selected ".

There must be a way to do this....

leatherback

Yes there is.

For input type=text add: value=\"$databaserecordvalue\"
for checkboxes: For those that are selected add checked in the checkbox delcaration: <input type="checkbox" checked>
For radio buttons I believe it is adding selected

for textarea you add the content of the database field between the <textarea....>$databaserecordvalue</textarea> tags.

zerogreen

Yes, thank You, I know.

What I mean is this:

the HTML for the inputbox will be something like this:
<input type=text name=box value="<?$databaserecord;?>"

but my problem lies with the select box:
<select name=select etc. etc. >
<option value="choice1" selected >choice1</option>
<option value="choice2">choice2</option>
etc.

Now that "selected " is what is the problem.

How can I get that to correspond with the choice the guy made originally.

Say in the original form he selected "choice1".
The databaserecord will the be "choice1", and not all of the choices available, because this is the records for just this guy's profile.

So when I do the Query, I know that originally this guy selected "choice1", but now when I want to have the selectbox again on the new form I want "choice1" to be 'selected '.
Obviously I will not put 'selected' in any of the options of the new form in HTML. I want PHP to do that to correspond with the original value.

Hope you understand what I mean.

leatherback

Hi,

There is a very long thread on this in the forum. I know we reached a solution to it (Somewhere about a onth or 2 ago). Have a search in the forum.

IF you build the select options out of the data abse, you could easily do it by getting the value which is selected from the database, and then an if statement when extracting the select options.

If you have the select options in text format (So you basically have a fixed set of options, you'll have to do somethin like:

where $selected is the choice the user has stored in the database. (So this could also be: $data[select])

Hope this helps?

kevinsequeira

example

.
.
.
$q = "select from from tablename where id=$id";
$q = mysql_query($q);
$r = mysql_fetch_array($q);
$choice = $r['choice'];// now u have the users choice;

<option value=choice1 <?php if($choice=="choice1") echo "selected";?>>choice1</option>

<option value=choice2 <?php if($choice=="choice2") echo "selected";?>>choice2</option>
.
.
.

reg
kevin

zerogreen

Thanx guys

...and in the end it was actually as simple as that.:rolleyes: