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 ?
