populating Form Options from table

Trainacomin · 1-15-05, 07:47 PM

I'm trying see if it's possible to populate an option on a form from one of my tables in my database. In my searching it appears it can be done but I can't find out how.
TIA
Clint

devinemke · 1-15-05, 11:09 PM

a very simple example:

PHP Code:


		
			
<form action="" method="POST">

<select name="options">



<?php

// assume already connected to db

$result = mysql_query('SELECT option FROM table');

while ($row = mysql_fetch_assoc($result))

{

    echo '<option>' . $row['option'];

}

?>



</select>

<br>

<input type="submit" name="submit" value="submit">

</form>

1-15-05, 07:47 PM	#1
Trainacomin Join Date: Mar 2004 Location: Aubrey,TX Posts: 35 Reputation: 5	populating Form Options from table I'm trying see if it's possible to populate an option on a form from one of my tables in my database. In my searching it appears it can be done but I can't find out how. TIA Clint

1-15-05, 11:09 PM	#2
devinemke broken tv Join Date: Dec 2001 Location: NYC Posts: 268 Reputation: 13	a very simple example: PHP Code: `<form action="" method="POST"> <select name="options"> <?php // assume already connected to db $result = mysql_query('SELECT option FROM table'); while ($row = mysql_fetch_assoc($result)) { echo '<option>' . $row['option']; } ?> </select> <br> <input type="submit" name="submit" value="submit"> </form>`

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search