Drop Down menu from a table?

[kperoni]

How do you populate a drop down menu from a table? Has anyone did this so i can save some time?

I have a HARDWARE database. When the user is to select what SITE their piece of hardware is located, I want that site drop-down menu to be populated by all site records from the SITE table.

I'd much appreciate any snipets! -Kevin

[kperoni]

btw, i'm using PostgreSQL as the database.

[hometoast]

I use this.. its uses the mysql db abstraction from PHPLib, but you can clearly see how it works. Plus phplib has pgsql abstraction too. You should be able to use the same thing.

function selectlist($sql,$textfield,$valuefield="",$name="") {
$d=new DB;
$d->Query($sql);
if ($name=="") {
$name=$textfield;
}
print "<SELECT name=$name>\n";
while ($d->next_record()) {
print " <OPTION ";
if ($valuefield != "") {
print "value=".$d->f($valuefield);
}
print ">". $d->f($textfield) . "</option>\n";
}
print "</select>\n";
$d->free();
}

[Anon]

Or you could do it like this (this has MySQL query functions in it, but they can easily be replaced for there PG counterparts:

print "<option selected value='nonsel'>-- None Selected --</option>";
$db_query = "SELECT something FROM somewhere ORDER BY something";
$db_query_exec = mysql_query($db_query);
$numrows = mysql_num_rows($db_query_exec);
for ($i=0; $i<$numrows; $i++)
{

$dbportalurls = mysql_fetch_row($db_query_exec);

print "<option value='".$dbportalurls[0]."'>".$dbportalurls[1]."</option>";
}

print "</select>";

[Anon]

Forget what I put in that last post, it was messy, here is an edited version with the pg query functions in it aswell :

print "<form><select size=1 name='foobar_select'>";
print "<option selected value='nonsel'>-- None Selected --</option>";

$db_query = "SELECT foo_id, foo FROM bar ORDER BY foo";
$db_query_exec = pg_exec($db_query);

$numrows = pg_numrows($db_query_exec);

for ($i=0; $i<$numrows; $i++)
{
$foobar = mysql_fetch_row($db_query_exec);

print "<option value='".$foobar[0]."'>".$foobar[1]."</option>";
}

print "</select>";
print "</form>";