Drop down menu/select from table fields

[Anon]

Hi,

How do I create a drop down menu on the web to select from one of the table's column data?

Thanks,
Winnie

[Anon]

Here is the code of a drop down which lists data from a table:

<SELECT NAME="field" SIZE="1">
<?
/ RUN QUERY /
$tmp=mysql ("DBASE", "select FIELDS from TABLE order by ORDER");
$count=mysql_num_rows($tmp);
$i=0;
while ($i<$count) {

/* ASSIGN NEW VARIABLES */
list($VAR1, $VAR2)=mysql_fetch_row($tmp);
?>
<OPTION VALUE="<?echo $VAR1;?>">
<?
echo $VAR2;
}
$i++;

}
?>
</SELECT>

Hope this helps.

[jmelnick]

try: (assumes connection mysql database)

<select name="options">
<?
$stuff="";
//
$query = "select concat('<option value=',value,'>',text,'</option>') as item from yourtable";

$result = mysql_query("mydatabase",$query);

while($row = mysql_fetch_array($result))
{
$stuff .= $row['item'];
}

echo $stuff;
?>
</select>

[Anon]

Hi Adam,

Thanks. But it still doesn't work. I am working with PHP3. Since the PHP code doesn't seem to work within the HTML, I decided to put the coding in PHP3 and have html pull from that file. How will that work? I connect to the database by $conn = pg_connect ("dbname=wcheng port=5432");

How do I put the coding in PHP3 and how should i type the html so that it pulls from the php3 file?

Thanks,
Winnie