Dependent drop downs

Anon

I am doing a project on Knowledge Management .In the first screen itself , i have three text fields. [ F1, F2, F3]. When i select something from F1 i should get only those things which are related to F1 in F2. Again F3 is dependent on F2.
For axample -I have Information Technology,Subjects in F1 and XML, ASP, PHP, History in F2 .
Now suppose i select Information Technology from F1 i should get only XML, ASP, PHP and not history in F2.
This all i have to create dynamically using a database. I am using PHP and Mysql. Please guide me.

Also let me know how should i create a database for this query.
Looking forward for ur reply.
Thanking you in advance.

Thank You
Subal Nawathe

Anon

Since all PHP code is processed server side you can't really do any "dynamic" changes after the page loads. You would be better off looking into some Javascript for your drop down menus.

More information is needed before a database course of action can be given. If you don't have it, get PHPMYADMIN, to do your database graphically. It will allow you to create/edit/delete the tables/columns you need visually.

kokatepranot

dear sir,

but i have been told that it should be dynamic. there should be something which creats this dynamic...????

i will mail u the databse details

thank you

Subal

Anon

To make it dynamic search for a javascript that will populate your boxes.

jc94062

SELECT * FROM table1 WHERE something='somethingelse'

That what your looking for?

kokatepranot

no actually i want :
3 select boxes named f1 f2 f3
f2 is dependent on f1 nad f3 is dependent on f2. which should take from database.

thank you.

jc94062

Thats gotta be done on the go then, look into Javascript, because PHP won't do it.