I am having some real difficulties with Dreamweaver and PHP/SQL, I would love some assistance!
I am not a coder; I have basic coding skills; I am doing this to help out a friend.
I have built a database using MySQL to store a bunch of organisations. It would be a very simple database (like one table!) except the organisations may have more than one location, or more than one service etc. therefore I have ended up with a database with 13 tables which looks like this:
What I want is for people to be able to click on a state they live in, and a list of all the types of services within that state to be displayed. Then when they select the type of service they want, a list of those services is displayed.
I am using Dreamweaver CS4 (as it is all I know) along with XAMPP to test it with. Funny enough, Dreamweaver is not playing nice with me.
I have created the first recordset and dynamic table to list all the states; that's the easy bit. I have named that location.php
I have then created a page called locationDisplay.php, and this is where it all falls down. I have started by creating really simple SQL statements just to test it, such as:
As you can see, when I test the page, it brings up nothing, only the two headings, no data.
Am I missing something really simple or is Dreamweaver playing up?
You assistance is greatly appreciated. Thank you for your help in advance. If you require any more information/screen shots in order to assist me, please let me know and I'll be happy to post it up.