MySQL::Seek PHP Method

Seek() public method

Sets the internal database pointer to the specified row number and returns the result
public Seek ( integer $row_number ) : object
$row_number integer Row number
return object Fetched row as PHP object
    public function Seek($row_number)
    {
        $this->ResetError();
        $row_count = $this->RowCount();
        if (!$row_count) {
            return false;
        } elseif ($row_number >= $row_count) {
            $this->SetError("Seek parameter is greater than the total number of rows", -1);
            return false;
        } else {
            $this->active_row = $row_number;
            $result = mysqli_data_seek($this->last_result, $row_number);
            if (!$result) {
                $this->SetError();
                return false;
            } else {
                $record = mysqli_fetch_row($this->last_result);
                if (!$record) {
                    $this->SetError();
                    return false;
                } else {
                    // Go back to the record after grabbing it
                    mysqli_data_seek($this->last_result, $row_number);
                    return $record;
                }
            }
        }
    }