Well I tried creating a function to read the full row but ran into a problem when returning the array through the function.
PHP Code:
public sql_row(Handle:con, const sql[]) {
new Handle:query, result;
new row[33][128];
query = SQL_PrepareQuery(con,sql);
if(!SQL_Execute(query)) {
server_print("%s :: MySQL query failed, stopping plugin", PLUGIN);
SQL_QueryError(query,sql_error,511);
set_fail_state(sql_error);
}
for(new i = 0; i < SQL_NumColumns(query); i++) {
SQL_ReadResult(query,i,row[i],127);
}
SQL_FreeHandle(query);
return row; // doesn't quite works this way I guess :(
}