function SelectLimit($sql,$nrows=-1,$offset=-1,$inputarr=false,$secs2cache=0)
	{
		if ($nrows > 0) {
			if ($offset <= 0) $str = " ROWS $nrows ";
			else {
				$a = $offset+1;
				$b = $offset+$nrows;
				$str = " ROWS $a TO $b";
			}
		} else {
			// ok, skip
			$a = $offset + 1;
			$str = " ROWS $a TO 999999999"; // 999 million
		}
		$sql .= $str;

		return ($secs2cache) ?
				$this->CacheExecute($secs2cache,$sql,$inputarr)
			:
				$this->Execute($sql,$inputarr);
	}
function SelectLimit($sql,$nrows=-1,$offset=-1,$inputarr=false,$secs2cache=0)
	{
		if ($nrows > 0) {
			if ($offset <= 0) $str = " ROWS $nrows ";
			else {
				$a = $offset+1;
				$b = $offset+$nrows;
				$str = " ROWS $a TO $b";
			}
		} else {
			// ok, skip
			$a = $offset + 1;
			$str = " ROWS $a TO 999999999"; // 999 million
		}
		$sql .= $str;

		return ($secs2cache) ?
				$this->CacheExecute($secs2cache,$sql,$inputarr)
			:
				$this->Execute($sql,$inputarr);
	}
function SelectLimit ( $ sql , $ nrows = - 1 , $ offset = - 1 , $ inputarr = false , $ secs2cache = 0 ) { if ( $ nrows > 0 ) { if ( $ offset <= 0 ) $ str = " ROWS $nrows " ; else { $ a = $ offset + 1 ; $ b = $ offset + $ nrows ; $ str = " ROWS $a TO $b" ; } } else { // ok, skip $ a = $ offset + 1 ; $ str = " ROWS $a TO 999999999" ; // 999 million } $ sql .= $ str ; return ( $ secs2cache ) ? $ this -> CacheExecute ( $ secs2cache , $ sql , $ inputarr ) : $ this -> Execute ( $ sql , $ inputarr ) ; }
SELECT FIRST 5 SKIP 2 col1, col2 FROM TABLE
SELECT FIRST 5 SKIP 2 col1 col2 FROM TABLE