Trebalo bi to da središ malo. Cela skripta ti je zbrda zdola
.
Prosledi page parametar u url-u:
PHP kôd:
<?php
include("include/config.php");
$page = isset($_GET['page'])?intval($_GET['page']):0;
$per_page = 10;
$start = $page?$page*$per_page:0;
$next_link = '<a href="?page='.$page++.'">Next</a>';
$prev_link = '<a href="?page='.$page--.'">Prev</a>';
$sql="SELECT * FROM diplomci order by ID_DIPLOMCA asc LIMIT $start, $per_page;";
$result=mysql_query($sql);
$i=0;
while($red=mysql_fetch_array($result))
{
echo'<table border="0" width ="450"><tr align="left" ><td bgcolor= "#606D84" width="8%" align="center"><FONT SIZE="3" color="#FFFFFF"><b>'.++$i.'.</b></FONT></td><td align="right"><FONT SIZE="3"><a href="profil.php?idDiplomca='.$red['ID_DIPLOMCA'].'">Pogledaj profil</FONT></a></td><tr></table>';?>
<?php echo'<b>Ime: </b>'; echo '<b>'; echo $red['IME']; echo'</b>' ?> <br><?php echo '<b>Prezime: </b>'; echo '<b>'; echo $red['PREZIME']; echo'</b>'?><br><?php echo '<b>Odsjek: </b>'; echo '<b>'; echo $red['SMIJER']; echo'</b>'?><br> <?php echo '<b>Status: </b>'; echo '<b>'; echo $red['STATUS']; echo'</b>';?><hr>
<?php
}
mysql_close();
echo "<div>$next_link $page $prev_link</div>";