<?php

	include 'core.php';

	$limit = 3;

	$sqlpages = "SELECT * FROM news";

	$respages = mysql_query($sqlpages) or die(mysql_error());

	$pages = mysql_num_rows($respages) / $limit;

 

	for($i = 0; $i < $pages; $i++){

		echo "<a href='testavimas.php?page=".$i."'>".$i."</a> ";

	}

 

	echo "<br><br>";

 

	$selectingFrom;

	if($_GET['page'] > 0){

		$selectingFrom = $_GET['page'] + $limit - 1;

	}else{

		$selectingFrom = 0;

	}

	$sql = "SELECT * FROM news WHERE id > ".$selectingFrom." ORDER BY id LIMIT ".$limit."";

	$res = mysql_query($sql) or die(mysql_error());

	while($row = mysql_fetch_assoc($res)){

		echo "<b>".$row['title']."</b><br>".$row['fullnew']."<br><br>";

	}

?>