option value derived from a mysql database

[jr8rdt]

I want to have option value data derived from a mysql database instead of having to put it /hardcoded the value in the php code. I have the data in the database already.

 

echo "<tr><td>User</td>";

                echo "<td><select name='user'>";

                echo "<option selected value='$user3'>$user3</option>";

                echo "<option value='John'>John</option>";

                echo "<option value='Kevin'>Kevin</option>";

                echo "<option value='Jason'>Jason</option>";

                echo "<option value='Pat'>Pat</option>";

                echo "<option value='Jeff'>Jeff</option>";

                echo "<option value='Paul'>Paul</option>";

                echo "<option value='Chris'>Chris</option>";

 

can you explain how it would work and give me an example?

Thanks

 

[fenway]

You'd retrieve the list from the SELECT query, iterate though the rows with mysql_fetch_assoc(), and then write out each option in sequence.