note 91607 deleted from sqlite3.changes by danbrown
| From: | danbrown@php.net | Date: | Fri, 19 Jun 2009 12:15:23 +0000 |
| Subject: | note 91607 deleted from sqlite3.changes by danbrown | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-157125@lists.php.net to get a copy of this message | ||
Note Submitter: Anonymous
----
Note that SQLite3::changes() returns 1 or more even if the row(s) was not actually changed.
<?php
...
$query = $db->exec('UPDATE counter SET views=0 WHERE page="test"');
if ($query) {
echo 'Number of rows modified: ', $db->changes();
}
$query = $db->exec('UPDATE counter SET views=0 WHERE page="test"');
if ($query) {
echo 'Number of rows modified: ', $db->changes();
}
?>
Will print
Number of rows modified: 1 // or more
Number of rows modified: 1 // or more