<?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 "Number of affected rows: " . $db->changes() . " by chained query.<br />\n";
?>
