[NeXoR]

Hey guys, according to SAMP WIKI MySQL (BlueG's)
Storing a string requires a string to store it inside

PHP код:

cache_get_field_content(0, "name", dest); 


Can I do like ?

PHP код:

PlayerInfo[playerid][pName] = cache_get_field_content(0, "name"); 


[jlalt]

no but you can do

PHP код:

cache_get_field_content(0, "name", PlayerInfo[playerid][pName]); 


also you can do

PHP код:

new dest[MAX_PLAYER_NAME];
cache_get_field_content(0, "name", dest);
format(PlayerInfo[playerid][pName], MAX_PLAYER_NAME,dest); 


[NeXoR]

Quote:

Originally Posted by jlalt no but you can do PHP код: cache_get_field_content(0, "name", PlayerInfo[playerid][pName]);  also you can do PHP код: new dest[MAX_PLAYER_NAME]; cache_get_field_content(0, "name", dest); format(PlayerInfo[playerid][pName], MAX_PLAYER_NAME,dest);

I'll try the second one, btw I know its pretty lame but what does "row index" means ? (starting in 0, according to WIKI)

[jlalt]

row index, for example when you do

PHP код:

SELECT * FROM `ACCOUNTS` WHERE `LEVEL` = '0' 


it will get the rows from latest guy registered with level 0 to oldest guy registered and has level 0 yet,
so if you do

PHP код:

cache_get_field_content(0, "name", dest); 


it will get latest guy name but if you do

PHP код:

cache_get_field_content(mysql_num_rows()-1, "name", dest); // -1 cause rows index start from 0 


it will get oldest guy name

so by that you can do a loop to get all players names which got level 0

PHP код:

for(new i = 0; i < mysql_num_rows(); i++) {
   cache_get_field_content(i, "name", dest);  
   printf(dest);
} 


[NeXoR]

Quote:

Originally Posted by jlalt row index, for example when you do PHP код: SELECT * FROM `ACCOUNTS` WHERE `LEVEL` = '0'  it will get the rows from latest guy registered with level 0 to oldest guy registered and has level 0 yet, so if you do PHP код: cache_get_field_content(0, "name", dest);  it will get latest guy name but if you do PHP код: cache_get_field_content(mysql_num_rows()-1, "name", dest); // -1 cause rows index start from 0  it will get oldest guy name so by that you can do a loop to get all players names which got level 0 PHP код: for(new i = 0; i < mysql_num_rows(); i++) {    cache_get_field_content(i, "name", dest);      printf(dest); }

So if I limit the query to 1 (LIMIT = 1)
I should use row 0 all the time, right ?

[jlalt]

Quote:

Originally Posted by NeXoR So if I limit the query to 1 (LIMIT = 1) I should use row 0 all the time, right ?

yea cause there just will be one row index

[NeXoR]

Quote:

Originally Posted by jlalt yea cause there just will be one row index

Thank you!