is relatively easy to access. When you search for a book on Amazon.com, for example you expect to find it within seconds of being on the site. You type a book name, click Search, and the results appear in a well-structured and elegant manner. If you visit eBay's website in an effort to find that treasure someone might be auctioning off, you type the name of the item you are looking for and select a form object, usually a Submit button, to perform the search. It's safe to say that in today's application service provider business model, most companies employ some mechanism for allowing their users quick access to the data that powers the company. It's true that the web took off with the inception of the modern search engine. Companies such as Yahoo, Excite, and Google fueled the medium we know as the web by making accessible the information contained within billions of websites on the Internet. Employing basic, filtered, and advanced methods of searching, those companies and others powered the Internet into what we know it as today. This chapter focuses on the ability to integrate these search methods into your web application, specifically providing your users with the capabilities to search for information that they need in your site. As you've done with the rest of the chapters in this book, you can work with the examples in this chapter by downloading the files from www.dreamweaverunleashed.com. Remember, you'll want to save the files for Chapter 27 (not the folder) in the C:\Inetpub\wwwroot\Dorknozzle<technology> directory, where <technology> represents the server technology (ASP, ASPX, CFM, PHP) you plan to use. Of course, make sure that your site is also properly defined in Dreamweaver, including the appropriate server-side technology you plan to use in the Testing Server category.           SQL Search Finding information in your database can be a simple or a complex process. Depending on the search criteria, you can give your users the capability to narrow down their searches as fine as a specific date range. Suppose that you wanted to find all employees in your database who have the name John Smith; you can create a simple query in Access that selects all the records in the Customers table whose name was equivalent to the name John Smith. Your SQL statement could look similar to this:   SELECT Name FROM Employees WHERE Name = 'John Smith'   The result returns all the matching records. Indeed, the Dorknozzle database is filled with information that users may want access to, including the following: Employees: As an admin, you can perform a search on your Employees table to extract employee-specific information including name, address, city, state, and so on. CreditCards: Again as an admin, you can perform a search on the CreditCards table to extract all the users' credit cards. EmployeeStore: Probably the most important container of information, the EmployeeStore table can be searched by an employee to narrow down an employee's search for a specific product. Orders: As an admin, you can perform a search to determine how many items you sold on a specific day, week, or month. You could also return a statistical analysis of those results so that you could better understand the employees'