Search function for Coursework 2

Now, I am doing a search function for coursework 2. The function will help user search their products by product ID or product Name .

At first step, I have to modify search form in 4 different pages such as home, product, about us, contact us following code:



Then I create another page called search.asp which contains all code relevant to searching function.

Declare all strings:



Making a connection to database



Inputting what entities I want to display then close the connection.



Now, I test my work on web browser. I type number 11 on the textfield then click button search
the result comes up for product ID 11




I type text as "blue" then get results below:



However, When I try some sign, there are no returning message.



Moreover, when I am searching some keyword, the database is displayed over the template. Although, I used REPEAT REGION to setup 2 records displaying like product page but the function is not working.



I have posted 2 topic gathering Search fuction created by Dreamweaver and by hand coding.

1. Search function Question for creating by Dreamweaver
   

2. Search function Question for creating by Dreamweaver