Posted by C. on 03/29/07 16:57

Hi,

First off, apologies for posting here - I can't find a dedicated
SQLite newsgroup

The other thing I can't find is how to retrieve the total number of
rows which would have been returned by a query if it did not have a
LIMIT and/or OFFSET clause.

(kind of like SQL_CALC_FOUND_ROWS/FOUND_ROWS() in MySQL)

TIA

C.

• Next in forum: Re: problem with $_SERVER['REQUEST_METHOD'] == 'POST'
• Prev in forum: automated upload with PHP
• Thread view: SQLite - total rows with limit and offset

[Reply to this message]