Storing a results query to <OPTION> list

[bigby2k]

Hi! I'm trying to figure out how to store query results into an tag. It's to look like this:

<OPTION VALUE="primay key value>"item value referenced by primary key"

I figure that a for loop can be used, but I'm somewhat lost on how to this.

Thanks,
Brian

[Anon]

I'm somewhat lost on your question. It can't be as simple as it sounds?

$query = "SELECT optionid,value FROM table";

$results = mysql_query($query,$db_connection);

echo "<select name=\"foo\">";

$while ($row=mysql_fetch_array($results)) {

echo "<option value=\"$row[0]\">$row[1]";

}

echo "</select>";

mysql_close($db_connection);

[spacemax]

mysql_connect ('localhost', username, pass );
mysql_select_db (dbname);
$query="select * table";
$result = mysql_query ($query);
if ($row = mysql_fetch_array($result)) {
do {?><option value="<?=$row["id"]?>"<?if($row["id"]==$whichidtoselect){
?> SELECTED <?}
?>><?=$row["columntoshow"]?>

<?} while($row = mysql_fetch_array($result));
mysql_close();

[Anon]

ooo fancier...! You could space it out a bit better since it looks like Brian is just trying to learn the language. Code like that makes me remember trying to learn Perl from other\'s cryptic examples.

cheers

[bigby2k]

I'm somewhat new to PHP. ;-) I forgot to mention that I was looking for an exampe for PostgreSQL, my apologies.