[Pawn] Help with mysql and data retrieving.

[cronoxliker]

Cache_get_data looks like deprecated i swaped it with cache_get_value_index_int, now, how do i now if it works, i tried with printf but it returns nothing, any idea? thanks for the time guys!



my try to print the factions name=



CMD:printtest(playerid,params[])

{

new query[140];

for(new i = 0; i < MAX_FACTIONS; i)

{

format(query, sizeof(query),"SELECT * FROM Factions WHERE ID = %d",i);

mysql_tquery(g_SQL,query);

printf("%s\n", Factions[i][Name]);

}

return 1;

}

prints 30 empty rows (yes i know there are rows in the db)



thanks!