Search in a Mysql database

1

I have made the following script to search in a Mysql database. The script works fine the first time you search. Second time if you try to search for some thing else the old search result keep appearing. Is there some way that i can clear the search result when ever i initiate in a new search?

This is my script:

this.createEmptyMovieClip(“myForm_europe”, 0);
myForm_europe.newSearch = 1;
myForm_europe.searchType = 0;
myForm_europe.searchArea = 0;
myForm_europe.pictureReq = “0”;
myForm_europe.fromYear = “0000”;
myForm_europe.fromMonth = “00”;
myForm_europe.fromDay = “00”;
myForm_europe.toYear = “0000”;
myForm_europe.toMonth = “00”;
myForm_europe.toDay = “00”;
myForm_europe.duration = “0”;
myForm_europe.continent = “1”;
myForm_europe.country = “$country”;
myForm_europe.region = “0”;
myForm_europe.rCity = “0”;
myForm_europe.rooms = “0”;
myForm_europe.oldContinent = “0”;
myForm_europe.oldCountry = “0”;
myForm_europe.oldRegion = “0”;
myForm_europe.getURL("…/search/searchResults.php", “_parent”, “POST”);

I have also tried this code:

this.createEmptyMovieClip(“myForm”, 0);
myForm.newSearch = 1;
myForm.searchType = 0;
myForm.searchArea = 0;
myForm.pictureReq = “0”;
myForm.fromYear = “0000”;
myForm.fromMonth = “00”;
myForm.fromDay = “00”;
myForm.toYear = “0000”;
myForm.toMonth = “00”;
myForm.toDay = “00”;
myForm.duration = “0”;
myForm.continent = “6”;
myForm.country = “$country”;
myForm.region = “0”;
myForm.rCity = “0”;
myForm.rooms = “0”;
myForm.oldContinent = “0”;
myForm.oldCountry = “0”;
myForm.oldRegion = “0”;
myForm.getURL("…/search/searchResults.php", “_parent”, “POST”);

Hope you have a solution

/Kafir

2

Maybe not the results are cached, but the searchResults.php site.

Try:

myForm.getURL("…/search/searchResults.php?rand="+Math.random(), “_parent”, “POST”);

3

Thanks for your quick reply. The result still doesn’t reset. Is there a script that can clear the cached information. This way when the flash loads it clears the cached information?

Or do you have any other suggestions towards this issue?

/Kafir