$perpage = 20; if( ( $count = mysql_query( "SELECT COUNT(*) AS total FROM winners ORDER BY id desc" ) ) ) { if( ( $total = mysql_result( $count, 0, 'total' ) ) ) { $page = $_GET['page'] ? $_GET['page'] : 1 ; $page = secure($page); $limit = ( $page - 1 ) * $perpage; $pages = ceil( $total / $perpage ); if( ( $result = mysql_query( "SELECT * FROM winners ORDER BY id desc LIMIT {$limit}, {$perpage}" ) ) ) { while( ( $mem = mysql_fetch_assoc( $result ) ) ) { print "$mem[date]{$mem['name']}$mem[amount]{$printout}$mem[host]"; } mysql_free_result( $result ); } if( $pages > 1 ) { echo "\n\nPage:"; for( $start = 1; $start <= $pages; $start++ ) { if( $start == $page ) { printf(" [%d]", $start ); } else printf( " %d\n", $start, $start ); } echo "\n\n"; } } mysql_free_result( $count ); } print "";