Dynamic table

where the content will be taken from a database

<?php
include 'config.php'; //you can define config.php or you can just connect from this file...

// how many rows to show per page
$rowsPerPage = 20; // this is where you can define how many rows would you like to display

// by default we show first page
$pageNum = 1;
$tablica = "something"; //you can define table here

if $_GET['page'] // defined, use it as page number
if(isset($_GET['page']))
{
$pageNum = $_GET['page'];
}

// counting the offset
$offset = ($pageNum - 1) * $rowsPerPage;

$query = "SELECT id, proizvod, cijena, tekst, slika
FROM $tablica "; //my teorethical db fields

$pagingQuery = "LIMIT $offset, $rowsPerPage";
$result = mysql_query($query . $pagingQuery) or die('Error, query failed');

// ispis
echo '<br><br><br><br><br><table align="center" border="5"><tr>';
$i = 1;
while(list($id, $proizvod, $cijena, $tekst, $slika) = mysql_fetch_array($result))
{

echo "<td align='center' height='120' width='160'>$slika<br>$proizvod<br>$cijena</b></td>
<p>$tekst</p>";

// here where i did some check cause I needed table 4x5 in dimensions.
if ($i==4) {echo "</tr><tr>";}
if ($i==8) {echo "</tr><tr>";}
if ($i==12) {echo "</tr><tr>";}
if ($i==16) {echo "</tr><tr>";}
if ($i==20) {echo "</tr><tr>";}


$i++;
}

echo '</tr></table>';
echo '<br>';

// how many rows we have in database
$result = mysql_query($query) or die('Error, query failed');
$numrows = mysql_num_rows($result);

// how many pages we have when using paging?
$maxPage = ceil($numrows/$rowsPerPage);

$self = $_SERVER['PHP_SELF'];

// creating 'previous' and 'next' link
// plus 'first page' and 'last page' link

// print 'previous' link only if we're not
// on page one
if ($pageNum > 1)
{
$page = $pageNum - 1;
$prev = " <a href=\"$self?page=$page\">prev</a> ";

$first = " <a href=\"$self?page=1\">first</a> ";
}
else
{
$prev = '..prev..'; // we're on page one, don't enable 'previous' link
$first = '..first..'; // nor 'first page' link
}

// print 'next' link only if we're not
// on the last page
if ($pageNum < $maxPage)
{
$page = $pageNum + 1;
$next = " <a href=\"$self?page=$page\">next</a> ";

$last = " <a href=\"$self?page=$maxPage\">last</a> ";
}
else
{
$next = '..next..'; // we're on the last page, don't enable 'next' link
$last = '..last..'; // nor 'last page' link
}

// print the page navigation link
echo "<div align='center'>";
echo $first . $prev . " Showing page <strong>$pageNum</strong> out of <strong>$maxPage</strong>" . $next . $last;
echo "</div>";