function UserDropDownMenu () {
global $xoopsDB;
$sql = "SELECT DISTINCT location FROM ".$xoopsDB->prefix("users")." ORDER BY location";
$result = $xoopsDB->query($sql);
echo "<SELECT name='location_text'>";
while ($location = $xoopsDB->fetchArray($result)) {
echo "<OPTION value='".$location["location"]."'>".$location["location"]."</OPTION>";
}
echo "</SELECT>";
}
Good work!
)
| Stats | |
| Goal: | $100.00 |
| Due Date: | May 31 |
| Gross Amount: | $0.00 |
| Net Balance: | $0.00 |
| Left to go: | $100.00 |
 |
|
