Function ze\sql::update()
In PHP:
ze\sql::update($sql, $checkCache = true, $checkRevNo = true)
Description
This function lets you run a SQL DELETE/INSERT/REPLACE/UPDATE against the current database.
Parameters
$sql
A string containing a SQL DELETE/INSERT/REPLACE/UPDATE query.
$checkCache
The CMS have a page caching feature which stores copies of content items in the cache directory. If you make a change to the database using this function then the CMS will attempt to work out what has just changed by looking for a table name in your SQL statement. If it can't find the table name then the entire cache will be cleared. You can disable this check by setting $checkCache to false, however this may cause visitors to a site to see out of date pages. If you want your database updates to be more cache-friendly, then you should use the deleteRow(), insertRow(), setRow() and updateRow() functions where possible as these functions give the CMS a better idea of what is being changed.
Return Value
Returns the result of the mysqli_query() function.
