View Single Post
Old 03/12/2019, 06:18 AM   #4
Calisthenics
High-roller
 
Join Date: May 2018
Posts: 1,148
Reputation: 175
Default Re: I need help with updating mysql from R5 to R41-4

`mysql_fetch_row_format` fetches whole row from the result set and moves to the next row pointer (if any).

As I wrote in the comments, `cache_get_value*` functions have `rowid` as first parameter. When there is only 1 row returned, you pass 0 as `rowid`. However when there can be multiple rows, we use a loop.

pawn Code:
while( mysql_fetch_row_format( savingstringexx ) )
// is equivalent to:
for (new i = 0, rows = cache_num_rows(); i < rows; i++)
and the sscanf splitting is replaced with `cache_get_value*` functions as shown in the previous reply.
Calisthenics is offline   Reply With Quote