PHP Database_Driver::buildSqlSelect Examples

Example #1

File: Mysql.php Project: maxwroc/PHP

 /**
  * Builds and returns the sql select statement
  * 
  * @param Database_Query $oQuery
  * @return string
  */
 protected function buildSqlSelect(Database_Query $oQuery)
 {
     $sSql = parent::buildSqlSelect($oQuery);
     if ($oQuery->limit() > 0) {
         $sSql .= ' LIMIT ';
         if ($oQuery->offset() > 0) {
             $sSql .= $oQuery->offset() . ', ';
         }
         $sSql .= $oQuery->limit();
     }
     return $sSql;
 }