drop menus in cascade

[Karyna]

hi guys im drivn nuts i was sure was easy but i do get it.. i have a table like this

item              clasif            out

-----------------------------------------

apple          fruit              lbs

orange        fruit              lbs

pumpkins    vegetable    box

banana        fruit              lbs

pineapple    fruit              box

 

i did 3 drop menus clasif  item  out  when the user select from 1st drop let say "fruit" the second drop must filter the database to all fruits and when select let say orange from 2nd drop the 3rd must contain just lbs... i try many ways but no one give me that filter!!!  plss will sombody helppp??

[scootstah]

SELECT * FROM table WHERE clasif = 'fruit';

SELECT * FROM table WHERE out = 'lbs

 

If you want to do it without a page reload you'll need to use AJAX.

[Barand]

If you want to do it without a page reload you'll need to use AJAX.

 

You can do it just with javascript, for example the baaSelect class in my sig

[scootstah]

You can do it just with javascript

 

Yeah, but then you'd have to fetch everything for JavaScript to work with.