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 LIMIT $offset, $rowsPerPage";
$result = mysql_query($query) 
or die(mysql_error()); 

#display results 
$i = -1; 
while ($row = mysql_fetch_array($result)) { $i++;  if ( $i >= 4 ) { $i = 0; echo "<br />"; } echo "<a href=\"$row[0]\" target=\"_blank\"><img src=\"$row[1]\" 
cellspace=\"5\" cellpadding=\"4\" border=\"2\" /></a>&nbsp;"; }


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



?>