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