Let's click on the author_id
column header.
We can confirm that the sort occurred by watching the SQL query at the top of
screen; it should contain an ORDER BY clause.
We now see a small red triangle pointing upwards beside the author_id header.
This means that the current sort order is 'ascending'. Moving the mouse cursor over
the author_id header makes the red triangle change direction, to indicate what will
happen if we click on the header: a sort by descending author_id.
Another way to sort is by key. The Sort dialog shows all the keys already defined.
Here we see a key named PRIMARY, the name given to our primary key on the isbn
field when we checked Primary for this field at creation time:
This might be the only way to sort on multiple fields at once (for multi-fields indexes).
The default initial sort order is defined in $cfg['Order'] with ASC for ascending,
DESC for descending, or SMART, which means that fields of type DATE, TIME,
DATETIME, and TIMESTAMP would be sorted in descending order, and other field
types in ascending order.
Chapter 4
[ 81 ]
Color-Marking Rows
When moving the mouse between rows, the row 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.
Pages:
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100