Databases Reference
In-Depth Information
This might be the only way to sort on multiple columns at once
(for multi-columns indexes).
The initial sort order is defined in $cfg['Order'] with ASC for ascending, DESC for
descending, or SMART ; the latter is the default sort order, which means that columns
of type DATE , TIME , DATETIME , and TIMESTAMP would be sorted in descending order,
whereas other column types will be sorted in ascending order.
Headwords
Because we can change the number of rows displayed on a page, it is quite possible
that we do not see the whole data. In this case, it would help to see headwords
indications about the first and last row of displayed data. This way, you can click on
Next or Previous without scrolling to the bottom of the window.
However, which column should phpMyAdmin base his headwords generation on?
A simple assumption has been made: if you click on a column's header to indicate
your intention of sorting on this column, phpMyAdmin uses this column's data as a
headword. For our current topic table, we do not have enough data to clearly notice
the benefits of this technique. However, we can nonetheless see that after a sort, the
top part of the screen now contains this message:
Showing rows 0 - 1 (2 total, Query took 0.0006 sec) [author_id: 1 - 2]
Here, the message between square brackets means that author_id number 1 is on the
first displayed row and number 2 is on the last one.
Color-marking rows or columns
When moving the mouse between rows (or between column headers),
the row (or column) background color may change to the color defined
in $cfg['BrowsePointerColor'] . This parameter can be found in
themes/<themename>/layout.inc.php . To enable this, browse pointer for all
themes— $cfg['BrowsePointerEnable'] —must be set to TRUE (the default) in
config.inc.php .
 
Search WWH ::




Custom Search