Hello, I am new to this site and to php and mySQL...and I need some help. I know this topic is all over the web but after a couple of days of looking and refering to several text books it still doesn't work so please bear with me.
I have created a web page with an associated mySQL database for our local women's golf club. I am trying to create a routine that will allow active members to get a web page displaying a listing of other members who live near them (in the same city/town). I have created a drop-down list in file 1 (memberSelect.php) with the following code below.
I want to pass the the value selected (town) to file 2 (activeMemberListing_NearMe.php) using the POST method. The code in file 2 is as follows below.
The While loop processes query results and displayes all records found. Note - I know this while loop works as it is taken from another file that successfully calls a SELECT statement and simply lists all active members of the club.
When I open file 1, select a city and click the "List Members" button I end up right back at file 1. This leads me to believe that I am passing nothing with the the "IF($cityID == 0)" code line in file 2 being true and thereby returning me to file 1.
I know this is a static selection list but before I move to a dynamic selection list I want to know why this doesn't work. Any help will be greatly appreciated.