5
fixed, should use
query() - execute a query. Note that if the request method is GET, this method will only accept SELECT queries. Returns a database resultset
queryF() - force an execution of a query without regard to request method. USE WITH CAUTION!!!
getRowsNum($resultset) - returns number of rows in a resultset
getAffectedRows() - returns number of rows changed by a query
getInsertId() - returns the auto_increment id of the latest insertion query
fetchRow($resultset) - returns an array of values from a row, indexed by number ($row?0, $row?1 etc.)
fetchArray($resultset) - returns an array of values from a row, indexed by fieldname ($row?'field1', $row?'field2' etc.)
quoteString($string) - ensures that a string is inserted in the database with proper quotes to avoid e.g. SQL injection