Convert database values into Dropdown List

JSR

Hi Guys, new to this forum, kinda new to PHP in general haven't been using it long, mostly creating forms for database and custom CMS modules.

Anyway, i'm building a html email tool from the ground up and just need some help with one thing.

How do i convert values from a database field into a html form drop-down list?

dalecosp

Well, the new function [man]convert_values_from_a_database_field_into_a_html_form_drop-down_list/man does something like that, so I've heard.

More seriously, if you can get the database info into an array, you could then loop through the array, outputting the necessary <select> and <option> tags.

At least, that's how I'd do it. IIRC, I have a couple of custom functions lying around that do just that. If you ask real sweet and give me the phone number of your single sister(s), maybe I could post them for ya.

Well, kidding on that last - wifey wouldn't like me having those nums.

Welcome to PHPBuilder, BTW!

sandthipe

function list_options(){
$sql = 'your sql statement';
$result = mysql_query($sql)
while($row = mysql_fetch_array($result)){
$fieldName = $row['field1'];
etc...
echo "<option value='$fieldName'>$fieldName</option>";
}
}