I have to create a simple page where there is a search box capable of searching certain fields and directly below that a directory stule listing to also find records. A simple example I have a table with Name, Address, Category. The category might be a yellow page listing (plumber, accountant, etc.). I don't mind using two tables (Customer Info, Categories) or One Customers. (I know I can select the categories from the table using Distinct and Order By in the SQL Statement if I only use one Table.) But what i am not sure how to handle is to get the simple Search Box followed by Hyperlink Categories that would then return appropriate records.
Ex: | Search Box | <--- Should be able to search by Name, Address, and/or Category.
Accountant Baker Plumber
Attorney Butcher Realtor
etc. etc. etc.
Thanks for your help...