'; for ($counter=1; $row = mysql_fetch_array($result); $counter++ ) { echo " $counter \n"; if ( $counter / 4 ) { echo "
"; } if ( $counter / 20 ) { echo "\n\n


\n\n\n"; } } echo ''; // print the random numbers while(list($val) = mysql_fetch_array($result)) { echo "$val
"; } echo '
'; // 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']; ?>