Go to the source code of this file.
Variables |
| | $sqlorderby = '' |
| | Creating the SQL statements.
|
| | $sqlsortkey = NULL |
| | $textlib = textlib_get_instance() |
| | $sqlwrapheader = '' |
| | $sqlwrapfooter = '' |
| switch($sortkey) | $sqlsortorder = $sortorder |
| | Calculate the SQL sortkey to be used by the SQL statements later.
|
| | $fullpivot = 1 |
| | Pivot is the field that set the break by groups (category, initial, author name, etc)
|
| | $params = array('gid1'=>$glossary->id, 'gid2'=>$glossary->id, 'myid'=>$USER->id, 'hook'=>$hook) |
| | $userid = '' |
| if(isloggedin()) switch($tab) | $count = $DB->count_records_sql("SELECT COUNT(DISTINCT(ge.id)) $sqlfrom $sqlwhere", $params) |
| | $limitfrom = $offset |
| | $limitnum = 0 |
| if($offset >=0) | $query = "$sqlwrapheader $sqlselect $sqlfrom $sqlwhere $sqlwrapfooter $sqlorderby" |
| | $allentries = $DB->get_records_sql($query, $params, $limitfrom, $limitnum) |
Variable Documentation
| $allentries = $DB->get_records_sql($query, $params, $limitfrom, $limitnum) |
Initially we aren't going to perform NOT LIKE searches, only MSSQL and Oracle
will use it to simulate the "-" operator with LIKE clause
Under Oracle and MSSQL, trim the + and - operators and perform simpler LIKE (or NOT LIKE) queries
Definition at line 266 of file sql.php.
Pivot is the field that set the break by groups (category, initial, author name, etc)
fullpivot indicate if the whole pivot should be compared agasint the db or just the first letter printpivot indicate if the pivot should be printed or not
Definition at line 42 of file sql.php.
| if ($offset >=0) $query = "$sqlwrapheader $sqlselect $sqlfrom $sqlwhere $sqlwrapfooter $sqlorderby" |
Creating the SQL statements.
SQL.PHP This file is include from view.php and print.php
- Copyright:
- 2003 Initialise some variables
Definition at line 12 of file sql.php.
| switch ($sortkey) $sqlsortorder = $sortorder |
Calculate the SQL sortkey to be used by the SQL statements later.
Definition at line 35 of file sql.php.
1.7.6.1 
