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
(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
