I'm unable to make the 3 dependent drop downs using the same database table.if i use the the another two tables it works fine.i want with only one database table to use
check this one in the above specified link they have taken 2 tables but here i need to retrive it from a single database table
my database table comprises of userid,fname,lname,email,phone,password,companyname,location,different crops
and the three dependent dropdowns are Company name,location and crop
in some companies have different branches so i need to display them when the company is got selected accordingly the branch available with the crops
Thanks in Advance..!![/QUOTE]
Well, if you are populating a list for the "User" to select from, you'll need three tables - to put in all the possible values for each.
If you are doing a search of entered values (to allow someone to filter out the list), then you could use that 1 table and pull distinct values for each field (3 queries).
Either way it's a bit complicated to answer in a forum post, but that tutorial may give you enough sample code to piece it together.