Untitled

<?php

mysql_connect("sql11.webair.com", "", "") or die(mysql_error());
mysql_select_db("") 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 

for ($i=0; $row = mysql_fetch_array($result); $i++ ) {
    echo "<a href=\"$row[0]\" target=\"_blank\"><img src=\"$row[1]\" cellspace=\"5\" cellpadding=\"4\" border=\"2\" /></a>&nbsp;";

    if ( $i % 4 ) { echo "<br />"; }
    if ( $i % 20 ) { echo "<br /><hr /><br />"; }
}


// 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'];



?>