<?php
$db = new sqlite_db(":memory:");
$db->query("CREATE TABLE foobar (misc CHAR(10))");
$db->query("INSERT INTO foobar (misc) VALUES('Tall')");

$db->query("
	INSERT INTO foobar (misc) VALUES('Wez');
	INSERT INTO foobar (misc) VALUES('Marcus');
	INSERT INTO foobar (misc) VALUES('Ilia');
	UPDATE foobar SET misc='Tal' WHERE misc='Tall';
");

/* When chained queries are used rows changed returns the
 * cumulative of all rows affected by executed queries. */
echo $db->changes() . "rows affected by chained query.";
?>