$recordset->getLastSqlCmd()

Up: class RecordSet

This returns a string containing the last SQL QUERY, UPDATE, or DELETE command issued by this class instance. That string is initialized by new RecordSet($parms, $table), $recordSet->update(), $recordSet->delete(), $recordSet->getSurnameChk().

$countries     = new RecordSet(array('name' => '^B'), 'Countries');
print "<p>sql=" . $countries->getLastSqlCmd() . "'</p>\n";
$countries->update(array('currency' => 'USD'));
print "<p>sql='" . $countries->getLastSqlCmd() . "'</p>\n";
$countries->delete();
print "<p>sql='" . $countries->getLastSqlCmd() . "'</p>\n";

This displays

sql='SELECT COUNT(*) FROM Countries WHERE LEFT(name, 1)='B''
sql='UPDATE Countries SET `currency`='USD' WHERE LEFT(name, 1)='B''
sql='DELETE FROM Countries WHERE LEFT(name, 1)='B''

Use of this method is preferred to passing boolean true as a parameter to the delete and update methods, and is required if output in JSON format is required.

Next: $recordSet->debugBacktrace($depth)