Forum Moderators: coopster
<select name="COMPANY_id">
<option></option>
<?php
$query1 = "SELECT DISTINCT COMPANY_id FROM addresses ORDER BY COMPANY_id DESC";
$result1 = mysql_query($query1);
$num_rows=mysql_num_rows($result1);
while ($row=mysql_fetch_array($result1))
{
$COMPANY_id = $row["COMPANY_id"];
echo "<option value=\"$COMPANY_id\">$COMPANY_id</option>";
}
echo "</select><br>";
?>
*************************************************
Here is the full script.
<snipped excessive code per Posting Guidelines [webmasterworld.com]>
[edited by: coopster at 4:11 pm (utc) on May 26, 2006]
[edit reason] excessive code [/edit]