RE: [PHP] Populate Popup Menu from Database

Hi Mike, Check out ADODB. It's a database abstraction layer for PHP that has functions to do this. (php.weblogs.com) Otherwise it's kinda easy to do this, here's some psuedo-code that shoudl get you going. <?PHP // Make your connection to your database // Select * from department ?> <SELECT name='departmentID'> <?PHP //While !EOF ?> <?PHP <option value="<PHP echo $rs->fields['departmentID']; ?>"><PHP echo $rs->fields['departmentName']; ?> ?> <?PHP // loop ?> </SELECT> =C= * * Cal Evans * Journeyman Programmer * Techno-Mage * http://www.calevans.com * -----Original Message----- From: Mike Tuller [mailto:php@ce.anoka.k12.mn.us] Sent: Saturday, June 29, 2002 10:42 AM To: php mailing list Subject: [PHP] Populate Popup Menu from Database I have some popup menus and want the items in the menu to be populated from a database. In this case I have a table that contains a listing of departments. I have a page that I can go in and add/delete departments, and want the changes to reflect in the menu the next time you go to the page. I searched for examples and found this: http://marc.theaimsgroup.com/?l=php-general&m=97628169623096&w=2 What is here is beyond my understanding, and seems like it is a little much for what I need. Here is what my database table looks like: Departments department_id department_name I just want to list the department name in the popup. Thanks, Mike -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php