MySQL has always made a great database. Now it's using commercial add-ons to also build a great database business. MySQL charts its way to paying customers with Query Analyzer - CNET ...

Right-click the PHP file you want to use to identify the existing table. Click "Open With" and select your PHP editor. Connect to the MySQL database.

To illustrate, suppose for example that you have a database called DB1 set up for a forum with a table called "posts" that includes four columns: ID, username, subject and content.

Now you have an existing MySQL database, so you can write the PHP code to perform the preceding steps. Begin with the search form. The code for this plain HTML form is shown in Listing 11.1.