Searching Data - Mastering phpMyAdmin 2.11 for Effective MySQL Management - page 147

Selection of Display Fields
The first panel facilitates a selection of the fields to be displayed in the results:
All fields are selected by default, but we can control-click other fields to make the
necessary selections. Mac users would use command-click to select / unselect
the fields.
Here are the fields of interest to us in this example:
We can also specify the number of rows per page in the textbox just next to the field
selection. The Add search conditions box will be explained in the Applying a WHERE
Clause section later in this chapter.
Ordering the Results
The Display order dialog permits to specify an initial sorting order for the results
to come. In this dialog, a drop-down menu contains all the table's columns; it's up
to us to select the one on which we want to sort. By default, the sorting will be in
Ascending order, but a choice of Descending order is available.
It should be noted that on the results page, we can change the sort order using the
techniques explained in Chapter 4, First Steps .