View Full Version : fill dropdown list with items when parent list changed

07-09-2006, 12:39 AM
I have two fields in my db size and colors I store my data like that:

size colors
8 red,blue
10 red
12 white

I have two dropdown lists the first for size and the second for size I made a select query and get the sizes I want but I want when I select a specific size the second list display the colors , also I know how to populate a comma seprated field but what should I do so the seconde list change its values

(without ajax please)


07-09-2006, 01:03 AM
if you want this done client side

server side will need to construct some arrays to populate the second select list

for example populate select script see


07-09-2006, 01:43 AM
thanks alot but how to get the colors value string from the database
(I have already a record set that have my colors values)