Select From information_schema

[chekisfast]

I am using the call SELECT tables FROM information_schema.tables to call all my tables to a drop down box. Then i call the same thing but i call the cloumn_names in another drop down box under the first drop down box. My question is how do make it that when the user chooses a table just the columns of the that specific tables are available in the drop down box.

[chazzy]

you need to use a javascript on change for the form field. similar to ajax or other sort of things, or just reload the entire page.