I am wondering if anyone knows how or if I can have a dropdown menu on a form of table entries.

EXAMPLE: Form asks what kind of home you want to build?

Table Homes has: Ranch, Cape, SaltBox, Two-Story, etc.

those choices would be in the drop down of choices.

This way if ever a new type of home is available then it could just be added to the table of homes instead of the page recoded to add another option?

Thank you in advance

EDIT -- I'm using PHP5 and MySQL BTW

__________________
http://www.mofiki.com - Macro's and other Automation Software

one table will contain three (3) columns.
a.) the item ID
b.) item name
c.) optionally, should it be displayed as available?

then you PHP will simply fetch all rows that should be displayed. in this regard, how are you going to display it? thru HTML? Java? or Flash?

I will just be displaying the options in an html form via <option></option> tags. There is already a table with all the options in it but this table will be updated frequently and i need whats updated in the tables to automatically be a choice on the form

Thank you for your response so far

__________________
http://www.mofiki.com - Macro's and other Automation Software

just do the usual "SELECT * FROM tablexxx WHERE available=1".

well i guess, that's all in it.