i have a table called category. In which i have two fields.namely categoryname and categoryid. CATEGORYNAME CATEGORYID ____________ ________________ AllenSolly 1 Apparrel&Accessories 2 Kitchen 3
similarly i have table called SUBCATEGORY.In which i have 3 fields namely SUBCATEGORYNAME PARENT_ID CHILDID _______________ ___________ __________ men 1 11 women 1 12 child 1 13 accessories 2 21 giftvoucher 2 22 shopbybrand 2 23
all i want is that to combine the table and extracting the data and to populate in a dropdown box so that under allensolly men women and child will come.and under apparrelaccessories accessories giftvoucher shopbybrand will come.If possible plz give me the code.Plz help me .