[armyoftwo]

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

[The_Gangstas]

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

[armyoftwo]

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

[The_Gangstas]

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..

[armyoftwo]

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

[Bumbis]

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

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

[wups]

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.

[armyoftwo]

Quote:

Originally Posted by wups This will select 10...30.

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

Es arī esmu Latvietis!