\n"; /* WHERE 1 is necessary to ensure that SQLite counts the deleted rows */ sqlite_query("DELETE FROM foobar WHERE 1", $db); echo "Number of affected rows: " . sqlite_changes($db) . " by delete.
\n"; sqlite_close($db); ?>