sqlite_changes

mIRC SQLite

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
}