Search / Results Page not showing results
Hello, I am designing a "catalog" website for my work, which requires a "search products" element.
I have read that I need to do this "dynamically" in PHP and MySQL and so have been learning how to do this, and so far I have managed to:
1) set up WAMP
2) create "4 products (will eventually be 300 when I know it works)" sample database and have it "talk" to Dreamweaver (CS6)
3) Set up the "search form button"
4) create a search_results.php page with the dynamic table to hold the data / recordset
5) Get the correct results when I "test" the recordset as shown below: (i.e using "black" as the search test word which does correctly shows the one product out of the 4 that has black in the description column)
click on pic below to view:
6) it looks like it added it to the table correctly in design view in dreamweaver:
7) but when I preview it in the browser and type in "black" into the search box I dont get any results? I only get the titles of the columns? (image below of the results I get in the browser):
I've been looking on the internet / adobe help and have the "dummies" books and lynda.com dvds, but i've yet to find clear step by step instructions on how to do this properly - every source tends to miss out important steps and offers no solutions - according to lynda.com training dvd, it should now just work!. Does anyone know what I should be doing - I appear to be going around in circles with this one? thanks.
PS I am a designer, and not a coder, and doing a dynamic site for the first time with no code knowledge, so please be gentle ![]()



