Someone

<?php
 
$conn = mysql_connect("sql11.webair.com", "", "") or die(mysql_error());
mysql_select_db("kol") or die(mysql_error());
 
// how many rows to show per page
$rowsPerPage = 24;
 
// by default we show first page
$pageNum = 1;
// if $_GET['page'] defined, use it as page number
if(isset($_GET['pagina']))
{
        $pageNum = $_GET['pagina'];
}
 
// counting the offset
$offset = ($pageNum - 1) * $rowsPerPage;
 
$query = "SELECT * FROM picpost";
$result = mysql_query($query) 
or die(mysql_error()); 
 
#display results 
 echo '  <table width="700"  border="0" align="center" cellpadding="0" cellspacing="0"><TR><TD>';
for ($counter=1; $row = mysql_fetch_array($result); $counter++ ) {
    echo "<a href=\"$row[0]\" target=\"_blank\"><img src=\"$row[1]\" cellspace=\"5\" cellpadding=\"4\" border=\"2\" /></a>&nbsp;$counter&nbsp;\n";
 
    if ( $counter / 4 ) { echo "<br />"; }
    if ( $counter / 20 ) { echo "\n\n<br /><hr /><br />\n\n\n"; }
}
 echo '</td></tr></table>';
 
// print the random numbers
while(list($val) = mysql_fetch_array($result))
{
        echo "$val <br>";
}
 
echo '<br>';
 
// how many rows we have in database
$query   = "SELECT COUNT(url) AS numrows FROM picpost";
$result  = mysql_query($query) or die('Error, query failed');
$row     = mysql_fetch_array($result, MYSQL_ASSOC);
$numrows = $row['numrows'];
 
// how many pages we have when using paging?
$maxPage = ceil($numrows/$rowsPerPage);
 
$self = $_SERVER['PHP_SELF'];
 
 
 
?>