library/database/class.sqldriver.php
public function GetWhereLike($Table = '', $Like = FALSE, $OrderFields = '', $OrderDirection = 'asc', $Limit = FALSE, $PageNumber = FALSE) {
      if ($Table != '') {
         $this->MapAliases($Table);
         $this->From($Table);
      }

      if ($Like !== FALSE)
         $this->Like($Like);

      if ($OrderFields != '')
         $this->OrderBy($OrderFields, $OrderDirection);

      if ($Limit !== FALSE) {
         if ($PageNumber == FALSE || $PageNumber < 1)
            $PageNumber = 1;

         $Offset = ($PageNumber - 1) * $Limit;
         $this->Limit($Limit, $Offset);
      }

      $Result = $this->Query($this->GetSelect());
      
      return $Result;
   }
public function GetWhereLike($Table = '', $Like = FALSE, $OrderFields = '', $OrderDirection = 'asc', $Limit = FALSE, $PageNumber = FALSE) {
      if ($Table != '') {
         $this->MapAliases($Table);
         $this->From($Table);
      }

      if ($Like !== FALSE)
         $this->Like($Like);

      if ($OrderFields != '')
         $this->OrderBy($OrderFields, $OrderDirection);

      if ($Limit !== FALSE) {
         if ($PageNumber == FALSE || $PageNumber < 1)
            $PageNumber = 1;

         $Offset = ($PageNumber - 1) * $Limit;
         $this->Limit($Limit, $Offset);
      }

      $Result = $this->Query($this->GetSelect());
      
      return $Result;
   }
public function GetWhereLike ( $ Table = '' , $ Like = FALSE , $ OrderFields = '' , $ OrderDirection = 'asc' , $ Limit = FALSE , $ PageNumber = FALSE ) { if ( $ Table != '' ) { $ this -> MapAliases ( $ Table ) ; $ this -> From ( $ Table ) ; } if ( $ Like !== FALSE ) $ this -> Like ( $ Like ) ; if ( $ OrderFields != '' ) $ this -> OrderBy ( $ OrderFields , $ OrderDirection ) ; if ( $ Limit !== FALSE ) { if ( $ PageNumber == FALSE || $ PageNumber < 1 ) $ PageNumber = 1 ; $ Offset = ( $ PageNumber - 1 ) * $ Limit ; $ this -> Limit ( $ Limit , $ Offset ) ; } $ Result = $ this -> Query ( $ this -> GetSelect ( ) ) ; return $ Result ; }
Builds the select statement and runs the query, returning a result
object. Allows a like clause, limit, and offset to be added directly.

@param string $Table The table from which to select data. Adds to the $this->_Froms collection.
@param mixed  $Like Adds to the $this->_Wheres collection using $this->Like();
@param string $OrderFields A string of fields to be ordered.
@param string $OrderDirection The direction of the sort.
@param int    $Limit The number of records to limit the query to.
@param int    $PageNumber The offset where the query results should begin.
Builds the select statement and runs the query returning a result object . Allows a like clause limit and offset to be added directly .