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!
> -----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.
> 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