[quote]<?php
//connection to the database
require 'config.php';
 
//max display per page
$per_page = 5;
 
//get start variable
    if(isset($_GET['start'])){
        $start = $_GET['start'];
    }else{
        $start = 0;
    }
 
//count records
$record_count = mysql_num_rows(mysql_query("SELECT * FROM igraci"));
 
echo "U bazi je $record_count igraca<br />";
 
//count max pages
$max_pages = $record_count / $per_page; //may come out decimal
echo "Bice prikazanu ukupno $max_pages strana u tabeli";
 
    if (!$start)
        $start = 0;
   
//display data
$get = mysql_query("SELECT * FROM igraci, $start, $per_page");
    while ($row = mysql_fetch_assoc($get))
    {
    //get data
    $id = $row['ID'];
    $naziv = $row['Ime'];
    $zemlja = $row['Zemlja'];
    $Pozicija = $row['Pozicija'];
    $Godine = $row['Godine'];
    $Visina = $row['Visina'];
    $Tezina = $row['Tezina'];
   
    echo $id;
    }
?>[/quote]