Itemizer PHP

[Virtue]

Hi

 

I have been looking at this and now I am wondering how do I put a pagination system at the Itemizer php from this

 

http://rathena.org/board/topic/60513-event-ticket-rewarder-php-log-viewer-anti-gm-corruption/

 

i tried myself but i am having no luck though.

[Digos]

Change this block to:

	// SQL query
	$limit = ( isset($_GET['limit']) ? intval ($_GET['limit']) : 0 );	
	$strSQL = "SELECT * FROM itemizer ORDER BY id DESC LIMIT ".$limit.", 100";

So, you will limit the result to 100 entries and can paginate in the browser (query string) by adding limit=(number)

Eg:

http://localhost/itemizer.php?limit=10 will display 100 results after the 10 first.