How would I...

[Dan_Coates]

In a recent post I wanted to know how you got a Form field listbox to display the table names of a database as it's individual items.

I got it to work!

Now however i'm trying to do another similar thing but can't figure it out, here's my dilema.

I have a listbox in another one of my forms and i have a table in a mySQL database with some info in, but i want my listbox to display the entries in a column that happens to be primary, so i don't get any duplicates. I want the listbox to display the entries in said column as it's items.

Do i do this in a similar way to how i did the table names?

I hope you can help!

Dan

[e-mail]

[LordShryku]

Yeah, same premise.

<select size="10">
<?php
$sql = "SELECT field FROM table";
$res = mysql_query($sql);
while($row = mysql_fetch_array($res)) {
?>
  <option value="<?php echo $row['field']; ?>"><?php echo $row['field']; ?></option>
<?php
}
?>
</select>

[Dan_Coates]

Cheers again LordShryku!

I think it's great how you guys/girls help out newbies like me, keep up the good work!

Dan