Search in a Mysql database

[kafir]

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");

Hope you have a solution

/Kafir

Moved to Server Side Scripting forum

[Curly Brace]

Why don't you attach your server-side script too?

[kafir]

Do you mean the searchResults.php? Do you know if there is any way where flash can clear the search result each time the flash is loaded?

/Mikael

[Curly Brace]

Yes, I mean this file and I thing the bug's in it

[tg]

sounds like you have a cache problem.... you might do a search, you might find the solution you need.