After the user has selected the country "US" - they are then going to select a state (Example; NY) and SUBMIT - DB / PHP displays output.
I need either PHP or MySQL to parse out only the records that qualify: US + NY
Here is the Country query that I'm using:
SELECT * FROM dealers WHERE Country = 'US'
Obviously, I could use a php IF/ELSE to only display the selected State records.
Instead, I'm hoping there's a way to edit the query listed above to handle this.
Yes, I am a MySQL newbie.