hi , i was wonder which one is better to use for getting player data from database when he logged-in , i have about user in my data base and i have to select user from this amount of users , currently i use something like this :
pInfo[playerid][score] = mysql_get ...
pInfo[playerid][skinid] = mysql_get ...
pInfo[playerid][money] = mysql_get ...
i mean i have 1 query per item! and i think this will make server LAG , should i get all items in a SELECT * query and then put them in variables? does it make any diffrent to avoid lag ? sorry i know my english is AWFUL but i guess i made my point!