[maddinat0r]

Quote:

Originally Posted by MP2 You could just get a free wiki. Anyway, when using R7, I did this to retrieve the rows in a while loop and put them in a string with delimiters: pawn Код: while(mysql_fetch_row_format(dest)) but that doesn't seem to work in R29 (mysql_fetch_row_format doesn't seem to return a value). How would I (using cache) go through every row and get a string with delimiters as a result? Hope you understand what I mean.

Use

pawn Код:

while(mysql_retrieve_row()) {
    mysql_fetch_row_format(dest);
    //other code
}

or

pawn Код:

for(new r=0; r < cache_num_rows(); ++r) {
    new dest[1024];
    for(new f=0; f < cache_num_fields(); f++) {
        if(f != 0) {
            strcat(destination, "|");
            
        }
        new row_val_tmp[256];
        cache_get_row(r, f, row_val_tmp);
        if(f == 0)
            strins(dest, row_val_tmp, 0);
        else
            strcat(dest, row_val_tmp);
    }
        //here you now have your values with a | delimiter, like "1|TestName|32512|Password"
}

And also stop using R29 and switch to R31! :P