I used to do something like this on MySQL:

$sth = $dbh->prepare("SELECT * FROM table");

if($sth->execute()){
    printf "Executed Statement - returned (%s) rows\n", $sth->rows;
}
[download]

and it returned a number of rows, found by SELECT, but, no matter, what SELECT variation I use with SQLite, even when it returns the actual row data with $sth->fetchrow_hashref(), it always returns 0 (zero).
Is there a way to determine the number of rows, found by select, if not with $sth->rows?