Pagination

[mikawhat]

I've got the following code. The first page is fine and i get links to the next pages. However when i click on one of those links i get an empty page. The page in the url is test.php?s=2&np=2

Anybody knows what i'm doing wrong?

<?php

require_once ('mysql_connect.php'); 
$page_title = 'test';
$display = 2;

if (isset($_GET['np'])) { 
	$num_pages = $_GET['np'];
} else { 
	$query = "select newsid, DATE_FORMAT(date, '%d/%m/%Y') as dr, title, brief, full, category from news order by newsid desc";
	$query_result = mysql_query ($query);
	$num_records = @mysql_num_rows ($query_result);

	if ($num_records > $display) { 
		$num_pages = ceil ($num_records/$display);
	} else {
		$num_pages = 1;
	}


if (isset($_GET['s'])) { 
	$start = $_GET['s'];
} else {
	$start = 0;
}

$query = "select newsid, DATE_FORMAT(date, '%d/%m/%Y') as dr, title, brief, full, category from news order by newsid desc LIMIT $start, $display";		
$result = @mysql_query ($query); 
$num = mysql_num_rows ($result); 

if ($num > 0) { 

	echo "<h1>News</h1>";

	if ($num_pages > 1) {

		echo '<p>';
		$current_page = ($start/$display) + 1;

		if ($current_page != 1) {
			echo '<a href="test.php?s=' . ($start - $display) . '&np=' . $num_pages . '">Previous</a> ';
		}

		for ($i = 1; $i <= $num_pages; $i++) {
			if ($i != $current_page) {
				echo '<a href="test.php?s=' . (($display * ($i - 1))) . '&np=' . $num_pages . '">' . $i . '</a> ';
			} else {
				echo $i . ' ';
			}
		}

		if ($current_page != $num_pages) {
			echo '<a href="test.php?s=' . ($start + $display) . '&np=' . $num_pages . '">Next</a>';
		}

		echo '</p><br />';

	} 


	echo '<table align="left" cellspacing="2" cellpadding="2">
	<tr><td align="left"><b>Date</b></td><td align="left"><b>title</b></td></tr>';

	$bg = '#eeeeee'; 
	while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
		$bg = ($bg=='#eeeeee' ? '#ffffff' : '#eeeeee'); 
		echo '<tr bgcolor="', $bg, '"><td align="left">', stripslashes($row[1]), '</td><td align="left">', $row[2], '</td></tr>

';
}

	echo '</table>';

	mysql_free_result ($result); 	

} else { 
	echo '<h3>No news.</h3>'; 
}

mysql_close(); 

}

?>

[helz]

are you getting the table layout there?
is this being displayed?

 echo '<table align="left" cellspacing="2" cellpadding="2">
<tr><td align="left"><b>Date</b></td><td align="left"><b>title</b></td></tr>';