I don't understand the second part of your question but for the first part you can use a select distinct in your SQL statement and then loop through the result to put things into a drop down box. I just printed the HTML with the var name in there and it worked well.
Good luck! -Natalie > -----Original Message----- > From: venomous [SMTP:[EMAIL PROTECTED]] > Sent: Monday, December 10, 2001 9:07 AM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] how to make a dropdown list with sql content > > I need to make a dropdown menu from my mysql database but i don't no how > to > come about > > > It's the meaning that i don't get weird things in my database for instants > > PI 300 or pi 300 > > > thanks in advanced > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > To contact the list administrators, e-mail: [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]