Weird MySQL ..
#1

pawn Код:
format(query, sizeof(query), "SELECT `airlinerank`, `username`, `earntforairline` FROM `users` WHERE `airline`='%d' ORDER BY `airlinerank` DESC LIMIT 12, 24", LookingAtAirline[playerid]);
                mysql_query(query);
                mysql_store_result();
Why does this result in 24 rows, instead of 12 rows?

Really, really weird.

Код:
[15:50:40] CMySQLHandler::Query(SELECT `airlinerank`, `username`, `earntforairline` FROM `users` WHERE `airline`='1' ORDER BY `airlinerank` DESC LIMIT 12, 24) - Successfully executed.
And after it - results in 24 rows, instead of what i wanted: 12 rows.


Anyone spot something wrong? It displays them fine, but too many of them!
Reply


Messages In This Thread
Weird MySQL .. - by GamingTurf - 15.12.2011, 16:28
Re: Weird MySQL .. - by GamingTurf - 15.12.2011, 16:35
Re: Weird MySQL .. - by GamingTurf - 15.12.2011, 16:48
Re: Weird MySQL .. - by GamingTurf - 15.12.2011, 17:02
Re: Weird MySQL .. - by GamingTurf - 15.12.2011, 17:26
Re: Weird MySQL .. - by GamingTurf - 15.12.2011, 18:24
Re: Weird MySQL .. - by Johnson_boy - 15.12.2011, 19:20

Forum Jump:


Users browsing this thread: 1 Guest(s)