Drop-down menu population..

[Anon]

I'm trying to populate a pop-up menu with a query. (so i can have a user select a department from the pop-up menu which lists all departments)

what am I doing wrong? any resources that you can point me to? Thanks, Kevin

<?php
$conn = pg_connect("host=postgres user=bla password=bla dbname=bla");

$sql="SELECT department FROM address ;";
$result_set = pg_Exec($conn, $sql);
$rows = pg_NumRows($result_set);

for ($j=0; $j < $rows2; $j++) {

$pos23 = pg_result($result_set, $j, "department");

   echo "<select size=1 name=department><option>$pos23</option></select>";

}
}
?>

[spider_man]

I don't know if that pg syntax is fine, but you don't have to put the <select> tag inside the for loop, just the <options> one, wich, besides, doesn't have any value.
Think about it, rewrite it and post it again if it doesn't work.
Good luck.

[Anon]

Check $rows2, it looks as if you meant to say $rows

<snip>
$rows = pg_NumRows($result_set);
for ($j=0; $j < $rows2; $j++) {
</snip>

[juneym]

I'm not a postgresSQL user but, what i can see in your code is that

for ($j=0; $j < $rows2; $j++) {

$pos23 = pg_result($result_set, $j, "department");

echo "<select size=1 name=department><option>$pos23</option></select>";
}

---

This will output,

<SELECT><option>posX/option></SELECT>
..
...
<SELECT><option>posN</option></SELECT>

it will then be rendered as separate select object in ur browser.. each select object contains only 1 select option. ? maybe you should do this one..

$select = "<select name = department>";

for ($j=0; $j < $rows2; $j++) {

$pos23 = pg_result($result_set, $j, "department");

$select .= "<select size=1 name=department><option>$pos23</option></select>";
} //for

$select .= "</SELECT>";

echo $select;

---

jun