... At least, I found it challenging. Hopefully someone here will find this a lot
I am developing a website wherein customers can log in, enter in the name and type
of their business (rather like the yellow pages.) I have a database of all the
customers, and each table in the database is another type of business. (For example,
in the table 'Gyms' all of the places where you can workout will be listed.)
Currently the database has no tables in it. When a new type of business registers,
then the table is created. In order to prevent many variations of the same table
from being created (I.E. Restaurants, Cafe's, Luncheonettes etc) I have customers
choose what type of business they are from a pull down menu.
Here is the challenge: I would like my users who come to browse to see a similar
pull down menu, but I want this menu only to list those types of businesses that have
registered. Essentially I would like the pull down menu customers see to be a dynamic
list of names of existing tables, updating for each new table that is created.
As for how to do this I'm stuck. It seems that it must be php that modifies an
html form. Any suggestions?? Deeply appreciated. Thanks.