Three Listboxes, Third Not Going Empty

I have three dependent listboxes that work well. Except for one thing. When you start they all say <Select>. However; when you go back to the first one, the third one ("Pig") doesn't revert back to <Select> untill you click on yje second one. Here is what I tried....

Dont you think when you click on the first one, the last one should empty and say <Select Area>? On the other hand, does it seem fine? I just want the thing to work properly without someone staring a new search and have leftovers from the last one. Thank you.

The only issue I encountered was, if you have selected something on each column and then click on the second column <--Select > statement it gives a mysql error as in the screenshot.Bildschirmfoto-2013-01-20-um-12..PNG

0

DS928Author Commented: 2013-01-20

hmmmmmmm, I can't seem to duplicate it? Why would that happen?
Is there a way to avoid it?

That's not browser sensitive. It's a server side issue, it cannot be browser sensitive. It's a mysql error caused by a function which is triggered without it's related parameter which comes from the second column. Maybe you're working with a local copy, which is slightly different from the online version?

Thank you. I am descending into heck here. I am having problems with populating the other boxes. Going straight across to top level......Place, Cuisine, City,State,Zip loading the first list works fine. Place works fine on the first second and third listboxes. Cuisine won't populate the second....here I am stuck..........also I have the problem if once you populate all three, then change one of the top five, the second and third listboxes do not empty! LOL!

Sid is not defined. So this variable isn't set when you call your script. Just check there.

0

DS928Author Commented: 2013-01-20

OK getting closer! Stay tuned! Thank you!

0

DS928Author Commented: 2013-01-21

Ok, I have all of my listbox options loaded. It was working fine except for the clearing of the boxes. First off, when you click on one of the five images, Kitty and Pig should empty, they are not, so I added this. It empties them, but also empties them whenever anything else is clicked, so it must be in the wrong place.....here is the code.

This is one of the five images across the top. Also it seems to be lagging? And acting crazy. Link is still active. It seems that if you refresh the whole page before starting a new search everything works fine. but there has to be a better way to do this. Even with the code that was suggested, the thing still acts wacky, refreshing the page is the only thing that clears it up at this point. Have been searching the internet all day, seems like any number of people have this problem, but I can't find a clear enough answer. At least something that I can understand.

0

DS928Author Commented: 2013-01-22

OK the only issue now sems to be the ability to refresh the two listboxes from the five buttons accross the top. And when you select a new search from the first istbox, the third listbox needs to empty. Heres the link.