MySQL... - Printable Version

MySQL... - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: MySQL... (/showthread.php?tid=199087)

MySQL... - armyoftwo - 14.12.2010

How can i for example store first 10 results then from 11 to 20, 21 to 30 is it possible?

Re: MySQL... - The_Gangstas - 14.12.2010

store them in a var,
mysql_query then
var = mysql_fetch_int
mysql_store_result
mysql_free.

Re: MySQL... - armyoftwo - 14.12.2010

Quote:

Originally Posted by The_Gangstas

store them in a var,
mysql_query then
var = mysql_fetch_int
mysql_store_result
mysql_free.

i don't need to fetch a int

Re: MySQL... - The_Gangstas - 14.12.2010

well what do you need? there are alot more natives S:

mysql_fetch_int( [connectionHandle = 1] )
mysql_fetch_field_row( string[], const fieldname[] [,connectionHandle = 1] )
mysql_fetch_float( &Float:result [,connectionHandle = 1] )
mysql_fetch_row_format( string[], const delimiter[] = "|" [,connectionHandle = 1] )

explain more..

Re: MySQL... - armyoftwo - 14.12.2010

I need to fetch first 0-10 results, 11-20, 21-30 etc..
So i can make pages for a book .. etc..

Re: MySQL... - Bumbis - 14.12.2010

query = "SELECT * FROM table WHERE bla='bla' LIMIT 10, 20"

This one worked for me in php, may work in samp too.

Re: MySQL... - wups - 14.12.2010

Quote:

Originally Posted by silvis123

query = "SELECT * FROM table WHERE bla='bla' LIMIT 10, 20"

This one worked for me in php, may work in samp too.

This will select 10...30.

Re: MySQL... - armyoftwo - 14.12.2010

Quote:

Originally Posted by wups

This will select 10...30.

Silvis thanks, wups, i know, i can read myself

Es arī esmu Latvietis!