PHP edit form for MySQL database using <Select> fields

[ghadley_00@yahoo.com]

Hi,

I have a php form that encodes the responses to various <Select> field
drop down menus as numbers (e.g. 0 to 50), and then posts the data to
a MySQL table. I am trying to implement a form to allow editing of the
data already in the table. I can read the data out of the database
without trouble, however I am having trouble figuring out a way to have
the appropriate option in the <Select> fields chosen to reflect the
data already in the database. Does anyone have any suggestions on how I
can accomplish this?

Best wishes,

George Hadley
ghadley_00@yaho o.com

[Roy W. Andersen]

Re: PHP edit form for MySQL database using &lt;Select&g t; fields

ghadley_00@yaho o.com wrote:
[snip][color=blue]
> I am having trouble figuring out a way to have
> the appropriate option in the <Select> fields chosen to reflect the
> data already in the database. Does anyone have any suggestions on how I
> can accomplish this?[/color]

Sure.

$data = mysql_fetch_arr ay(mysql_query( 'SELECT fieldname FROM table WHERE
id='.$theId));

echo '
<select name="mylist">
<option value="option1" '; if ($data['fieldname'] == 'option1') { echo '
selected="selec ted"'; } echo '>Option 1</option>
<option value="option2" '; if ($data['fieldname'] == 'option2') { echo '
selected="selec ted"'; } echo '>Option 2</option>
';
....etc...
echo '</select>';

This is how I do these things atleast. The point is to check if the
option is the one in the db, and if it is, add selected="selec ted" (or
just selected if you're not using xhtml).


Roy W. Andersen
--
ra at broadpark dot no / http://roy.skyggenesdal.org/

"Hey! What kind of party is this? There's no booze
and only one hooker!" - Bender, Futurama