here is the function sqlite3_num_rows

[Dennis Kaplan]

Drop in and test following:

!!! replace database and table name !!!

<?php
$db = sqlite3_open("yourSQLite.db")
$query = "SELECT * FROM YourTable";
$dbRes = sqlite3_query($db, $query);

function sqlite3_num_rows($dbRes)
{
    $n = 0;
    while(sqlite3_fetch_array($dbRes) != '')
    {
        $n = $n + 1;
    }
    return $n;
}
echo "Number of rows: " . sqlite3_num_rows($dbRes). "<br>";
?>

[bfleisch]

Hi Dennis,

Why don't you use PHP built-in function sizeof() ?

Ex:

$my_array = sqlite3_num_rows($dbRes);

echo "Number of rows: " . sizeof ($my_array);

Bruno

[Anonymous]

because it returns number of cells, not rows. and it's never 0 even of table is empty it's 1.