$server = "localhost";
$user = "username";
$pass = "password";
$databasename = "yourDBname";
$db = mysql_connect($server, $user, $pass);
	mysql_select_db($databasename,$db);
 
		$sql = "SELECT * FROM yourtable WHERE yourconditions ORDER BY your_order ";
		$query = mysql_query($sql,$db);
		$total_results = mysql_num_rows($query);
		$limit = "15"; //limit of archived results per page.
		$total_pages = ceil($total_results / $limit); //total number of pages
if (empty($page))
	{
		$page = "1"; //default page if none is selected
	}
$offset = ($page - 1) * $limit; //starting number for displaying results out of DB
 
	$query = "SELECT * FROM yourtable WHERE yourconditions ORDER BY your_order LIMIT $offset, $limit";
	$result = mysql_query($query);
//This is the start of the normal results...
 
	while ($row = mysql_fetch_array($result))
		{
			// display your results as you see fit here.
		}
		mysql_close();
 
 
// This is the Previous/Next Navigation
echo "<font face=Verdana size=1>";
echo "Pages:($total_pages)&nbsp;&nbsp;"; // total pages
if ($page != 1)
{
echo "<a href=$PHP_SELF?page=1><< First</a>&nbsp;&nbsp;&nbsp;"; // First Page Link
$prevpage = $page - 1;
echo "&nbsp;<a href=$PHP_SELF?page=$prevpage><<</a>&nbsp;"; // Previous Page Link
}
    	if ($page == $total_pages) 
			{
      			$to = $total_pages;
    		} 
		elseif ($page == $total_pages-1) 
			{
      			$to = $page+1;
    		} 
		elseif ($page == $total_pages-2) 
			{
     		 	$to = $page+2;
    		} 
		else 
			{
      			$to = $page+3;
    		}
    	if ($page == 1 || $page == 2 || $page == 3) 
			{
      			$from = 1;
    		} 
		else 
			{
      			$from = $page-3;
    		}
 
for ($i = $from; $i <= $to; $i++)
 
	{
	if ($i == $total_results) $to=$total_results;
	if ($i != $page)
		{
		echo "<a href=$PHP_SELF?showold=yes&page=$i>$i</a>";
		}
	else
		{
		echo "<b><font face=Verdana size=2>[$i]</font></b>";
		}
	if ($i != $total_pages)
		echo "&nbsp;";
	}
if ($page != $total_pages)
{
$nextpage = $page + 1;
echo "&nbsp;<a href=$PHP_SELF?page=$nextpage>>></a>&nbsp;"; // Next Page Link
echo "&nbsp;&nbsp;&nbsp;<a href=$PHP_SELF?page=$total_pages>Last >></a>"; // Last Page Link
}
echo "</font>";
 
// This is the end of the Previous/Next Navigation

<?php
include('config.php');
$db = mysql_connect($dbserver, $dbuser, $dbpass); 
	mysql_select_db($dbname,$db); 
		$sql = "SELECT id,big,thumb,postdate, DATE_FORMAT(postdate, '%d/%m/%Y @ %T ') AS pdate FROM screenshots ORDER BY id DESC"; 
		$query = mysql_query($sql,$db); 
		$total_results = mysql_num_rows($query); 
		$limit = "12"; //limit of archived results per page. 
		$total_pages = ceil($total_results / $limit); //total number of pages
 
if (empty($page)) 
	{ 
		$page = "1"; //default page if none is selected 
	} 
$offset = ($page - 1) * $limit; //starting number for displaying results out of DB 
	$query = "SELECT id,big,thumb,postdate, DATE_FORMAT(postdate, '%d/%m/%Y @ %T ') AS pdate FROM screenshots ORDER BY id DESC LIMIT $offset, $limit"; 
	$result = mysql_query($query); 
//This is the start of the normal results... 
$screen_id = mysql_result($result,$row,"id"); 
$screen_b = mysql_result($result,$row,"big");
$screen_t = mysql_result($result,$row,"thumb");
$screen_date = mysql_result($result,$row,"pdate");
 
	while ($row = mysql_fetch_array($result)) 
		{ 
		echo "$screen_t"; // display your results as you see fit here.
		} 
		mysql_close();
 
***CUT***

 
***CUT***
 
while ($row = mysql_fetch_array($result)) 
 {
 echo "<a HREF=images/ingame/".$row['big']." TARGET=_blank><img src=images/ingame/thumbs/".$row['thumb']." border=0 alt=".$row['big']."></a>&nbsp;&nbsp;"; // display your results as you see fit here.
 }
 
***CUT***

<tr>
  <td> code for picture in row 1</td>
</tr>
 
<tr>
  <td> code for picture in row 2 </td>
</tr>

echo "<table><tr>";
while ($row = mysql_fetch_array($result)) 
 {
 echo "<td><a HREF=images/ingame/".$row['big']." TARGET=_blank><img src=images/ingame/thumbs/".$row['thumb']." border=0 alt=".$row['big']."></a></td>"; // display your results as you see fit here.
if (($row % 3) == 0)
  { echo "</tr><tr>"; }
 }
</tr></table>

$counter=0;
echo "<table><tr>";
while ($row = mysql_fetch_array($result)) 
 {
  echo "<td><a HREF=images/ingame/".$row['big']." TARGET=_blank><img src=images/ingame/thumbs/".$row['thumb']." border=0 alt=".$row['big']."></a></td>"; // display your results as you see fit here.
 $counter++;
 if (($counter % 3) == 0){
  echo "</tr><tr>"; 
  }
}
echo "</tr></table>";