Drop Down List Not displaying all the dynamic options
I'm attempting to modify the users_Registration_Simple.php page by adding a drop down option to choose a country.
I've been trying to solve this for two days now and it's totally baffled me.
If you go here you can see the page in operation.
The Country dropdown should give a list of two countries (UK and US) which are taken from a recordset. As you can see it only lists the UK. As an aside I have, when experimenting, added several other countries to this list and it always only shows the UK even when the UK is not first in the list in the MySql database.
The list below (Region) displays fine as you can see.
At the bottom of the page is an error that says:
Warning: mysql_free_result(): 25 is not a valid MySQL result resource in /home/wltmdati/public_html/testing/users_Registration_page.php on line 432
Line 432 is: "mysql_free_result($rsCountry);"
I think this is related to the URSP because on a completely new page here the two options (UK and US) show as they should. So there must be something in the URSP page that is causing this.
Does anybody have any idea what the solution might be? I'd be most grateful of a pointer in the right direction.