sqlite_changes
Returns a number of affected rows of the last INSERT, UPDATE or DELETE query.
Syntax
$sqlite_changes ( conn )
|
Parameters
conn
The connection identifier.
Return Value
The number of affected rows on success, or $null if there was an error.
Example
; This code assumes a connection is already established and stored in %db
var %sql = UPDATE publishers SET publisher = 'Square Enix' WHERE publisher = 'Squaresoft' if ($sqlite_exec(%db, %sql)) { echo -a Number of rows affected: $sqlite_changes(%db) sqlite_free %res } else { echo -a Error executing query: %sqlite_errstr } |