mysql to scriptcase macros

i want scriptcase macro which can replace mysql_num_rows();
to count number of rows which are in result set.
mysql_field_names() ===? macro in scriptcase to get field names of a table.
mysql_num_fields()===? macro in scriptcase to count number of fields in a table.

i want to replace all my mysql functions with scriptcase macros.

As mentioned in this thread: http://www.scriptcase.net/forum/showthread.php?9598-count-the-number-of-rows-from-result-set-of-sc_select-macro

Using sc_select you get an ADORecordset and you can get all this info.http://phplens.com/lens/adodb/docs-adodb.htm