What I have (software)
Dreamweaver CS3; Wamp; Apache 2.2.11; php 5.3.0; MySQL 5.1.36
What I know (thanks Killersite U).:
? How to create Dreamweaver html webpages including html forms
? How to create MySQL db?s and tables
I plan to have these MySQL tables for my website database (these I know how to do):
? A client_info table that will include password, name, client_id, etc.
? A product_info table that will include product_id, product_image, client_id, product_description, etc.
In my website I plan to have:
? A login form;
? A product input form (The client will fill this form in as products become available.)
? The product input form will contain all the fields of the product_info table plus some of the fields from the client_info table. I want the client_info fields of the form to automatically fill because of the login
? A webpage that lists all the regions that would be in the product_info table. When a region is clicked, a webpage appears that lists all the products of that region along with a clickable client name beside each product which takes the visitor to the client?s website
If this were a Microsoft Access project and the webpages were reports, I could make all this happen because I know what to do behind the scenes, however here I do not know what to do, to get the info from the form to the table nor how to get the info from the tables to a page on the web and how to join the tables, how and where to construct the queries, the syntac, etc.
I subscribe to Killersite U and have watched the Beginner Dreamweaver, and beginner php and mysql which have been invaluable in getting me this far but I am not there yet
Can anyone advise me as to what videos to watch, literature to read, etc. to learn the above things.
Thanks
Don