Chapter 1
Account Overview


Chapter 2
Getting Started


Chapter 3
Control Panel Overview


Chapter 4
FTP Instructions


Chapter 5
SSH / Telnet


Chapter 6
Email Software Setup


Chapter 7
File Manager


Chapter 8
Change Password


Chapter 9
Mail Manager


Chapter 10
Site Statistics


Chapter 11
Mailing List


Chapter 12
Microsoft FrontPage


Chapter 13
Site Creation Tool


Chapter 14
Counters


Chapter 15
Protect Directories


Chapter 16
Redirect URL


Chapter 17
Search Engine


Chapter 18
Formmail


Chapter 19
PGP & PGP Mail


Chapter 20
Mime Types


Chapter 21
Anonymous FTP


Chapter 22
Archive Manager


Chapter 23
SSL (Secure Server)


Chapter 24
MySQL


Chapter 25
Shopping Cart


Chapter 26
CGI-bin


Chapter 27
Real Audio / Real Video


  


Chapter 24 - MySQL



Advanced Queries

Queries are built by selecting the fields to search on and the criteria to use for the search. The SQL statement that will be executed is displayed in the textbox in the lower right. The statement is updated to reflect the values provided in the rest of the form fields on the page by pressing the "Update Query" button. Execute the statement by pressing on the "Submit Query" button.

Each column can be used to specify a field for the SQL statement. Empty columns are ignored.

The fields specified in the "Fields" row are combined with criteria below it to create a WHERE clause. If the "Show" checkbox in on then the field is placed in the SELECT clause as well. The query results may be sorted on a field based on the selection in the "Sort" menu.

More fields can be added by turning on the "Ins" checkbox below a column or selecting a positive number in the "Add/Delete Field Columns" menu. Fields are deleted by turning on the "Del" checkbox or selecting a negative number in the "Add/Delete Field Columns" menu. Press "Update Query" to update the page to reflect the changes. You may have to scroll your web browser to the right to see all of the field columns.

The tables selected in the "Use Tables" listbox form the FROM clause. Also, the fields listed in the "Fields" menus are restricted to the fields in the selected tables.

Each criteria should be placed on a separate criteria row. If the "And" radio button is selected for a criteria row, that row will be logically AND'd in the WHERE clause. If the "Or" radio button is selected, that row will be logically OR'd in the WHERE clause.

Criteria are not required for any column. If not provided and the "Show" checkbox is on, the field will be shown for all records that match any other criteria.

Criteria are added and deleted in a  manner similar to adding/deleting fields using the checkboxes to the left of a criteria row or the "Add/Delete Criteria Row" menu. Again, press "Update Query" to update the page.