Let me give this a shot :P
<?
Mysql_connect("sqlserver","user","pass");
Mysql_select_db("db");
$resultset = mysql_query("select DISTINCT identifier, displayname from
table");
for($i=1;$i<=mysql_num_rows($resultset);$i++)
{
$object = mysql_fetch_object($resultset);
$identifier = $object -> identifier;
$displayname = $object -> displayname;
print "<option value=\"$identifier\">$displayname</option>";
}
?>
I do believe that should do it. Correct me if I missed anything.
Ryan
-----Original Message-----
From: Leotta, Natalie (NCI/IMS) [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 01, 2002 2:10 PM
To: PHP
Subject: RE: [PHP-DB] Display in drop-down box
Try doing a select distinct on that field and then loop through the results,
adding each one to your drop-down box as you go.
I don't have the exact code anymore because we stopped doing it that way,
but that's the basic idea of how to go about it.
I hope it helps!
-Natalie
> -----Original Message-----
> From: Alvin Ang [SMTP:[EMAIL PROTECTED]]
> Sent: Friday, March 01, 2002 2:07 PM
> To: PHP
> Subject: [PHP-DB] Display in drop-down box
>
> Hi there,
>
> I was wondering if anyone would be kind enough to show me how to select a
> field from a table in mysql and display it in a drop-down combo box?
>
> I am trying to show my users a list of all the parts from a table so that
> they can edit or delete it.
>
> Thanks!
>
> Alvin
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
