Richest gold mine
";
while($row = mysql_fetch_array($result))
{
$row['name'] = stripslashes($row['name']);
echo 'Gold mine '.$row['name'].' collected gold '.$row['jitel'].' ';
}
echo"";
$query = "SELECT COUNT(name) AS numrows FROM grad";
$result = mysql_query($query) or die('Error, query failed');
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$numrows = $row['numrows'];
$maxPage = ceil($numrows/$broinastranica);
$self = $_SERVER['PHP_SELF'];
$nomeranastranici = '';
for($page = 1; $page <= $maxPage; $page++)
{
if ($page == $pageNum)
{
$nomeranastranici .= " $page ";
}
else
{
$nomeranastranici .= " $page ";
}
}
if ($pageNum > 1)
{
$page = $pageNum - 1;
$predishna = " << ";
$parva = " first ";
}
else
{
$predishna = ' ';
$parva = ' ';
}
if ($pageNum < $maxPage)
{
$page = $pageNum + 1;
$sledvashta = " >> ";
$posledna = " last ";
}
else
{
$sledvashta = ' ';
$posledna = ' ';
}
// показваме
echo "Page: $parva $predishna $nomeranastranici $sledvashta $posledna ";
?>
© 2010 - All Rights Reserved. By Gold mine