I have a a table named "clients" and has the attributes of "type_company" "company_name" these are the attributes that the user will search for when looking for a client.
So I have created a form with a input text box that allows the user to enter what the want to search like they will type a company name that links to the company_name attribute. And alos a submit button.
But what I need to know is how to create a search tool that will search the name entered in the text box in the client table when the submit button is pressed. And when found in the database it will bring all the information stored on that clients name to the form for the user to view or edit if they wish. And when its not found it will give a message that the client does not exist and to choice another one.
I hope someone can help me with this I would be really greatful 🙂
