Generating drop don choices in a from based on SQL entries

[lightnb]

I want to have a form with a drop down box, where all of the choices it gives are from a field in a table in a database.

For example, if the first 5 entries of my database are:

Make Model Year

Dodge Neon 97
Dodge Neon 98
Dodge Neon 99
Ford F 150 03
Ford F 250 04

I want a Form to appear with a "make" drop down box that gives the choices:

Dodge
Ford

Is that possible?

Thanks,

Nick

[Eric]

Sure, you could probably do something like:

PHP Code:

<select name="make">
<?php

$query = mysql_query("SELECT DISTINCT Make FROM your_table");

$options = '';

while ($row = mysql_fetch_array($query))
{
    $options .= '<option value="'.stripslashes($row['Make']).'">'.stripslashes($row['Make']).'</option>';
}

echo $options;

?>
</select>

[lightnb]

cool. Thank you.

[Dax IX]

Is there an updated version of how to do this? I could have sworn I saw something about how to construct forms in newer versions, but I can't seem to find it now.

Also, is there a list of all functions, etc for vBulletin anywhere?

Thanks!

[Dismounted]

<a href="http://members.vbulletin.com/api/" target="_blank">vBulletin API</a>

[Dax IX]

Thank you. After more searches I came across that PDF.