The first code block is to reset the recordset to the first record. in mysqly, use the following:
The second code block is a standard recordset with parameters.
Examine the original recordset by editing it in DW to open the DW recordset panel.
Note the SQL and the parameters that are displayed, the names, type, default value and run time value for each.
then open the MySQLi recordset panel to recreate it.