Pagination

[jbachris]

I have this code, below that displays all the news items in the database. What I am trying to do is setup pagination so that only 10 display per page. I've looked and haven't found anything that I can understand well enough to do...

<? 
// includes 
include("xxx.php");

// open database connection 
$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!"); 

// select database 
mysql_select_db($db) or die ("Unable to select database!"); 

// generate and execute query 
$query = "SELECT ID, headline, date_format(date, '%b.%e.%Y')as todays_date FROM news ORDER BY date DESC"; 
$result = mysql_query($query) or die ("Error in query: $query. " . mysql_error()); 

// if records present
if (mysql_num_rows($result) > 0)
	{
	// iterate through resultset
	// print article titles
			while($row = mysql_fetch_object($result))
			{
?>
	<a href="news_detail.php?ID=<? echo$row->ID; ?>"><strong><? echo$row->headline; ?></strong></a><br>
<?
			}
	}
// if no records present
// display message
	else
	{
?>
		<li><b>No news items currently available.
<?
	}

// close database connection
mysql_close($connection);
?>

[artlover]

$query .= " LIMIT ".$start.", 10";

[jbachris]

Here is what I have. Currently it is not working in two ways that I am looking for help with:

1. It is not displaying any of the fields. It outputs 10 rows, but they are blank.
2. There are 30 entries in the table 'player' but when I run the .php page it lists only 10 and the pagination at the bottom only displays it as 1 page is there.

<?php

@mysql_connect('xxx', 'xxx', 'xxx') or die("ERROR--CAN'T CONNECT TO SERVER");
@mysql_select_db('xxx') or die("ERROR--CAN'T CONNECT TO DB");

$limit          = 10;               

$query_count    = "SELECT count(*) FROM player";    

$result_count   = mysql_query($query_count);    

$totalrows      = mysql_num_rows($result_count); 

if(empty($page)){
	$page = 1;
	}

$limitvalue = $page * $limit - ($limit); 
$query  = "SELECT * FROM player LIMIT $limitvalue, $limit";        
$result = mysql_query($query) or die("Error: " . mysql_error()); 

if(mysql_num_rows($result) == 0){
	echo("Nothing to Display!");
}

while($row = mysql_fetch_array($result)){
?>
	<tr>
		<td class="recentnewsContent">
			<table width="100%" cellpadding="4" cellspacing="0" border="0" align="center">
				<tr>
					<td align="left" valign="center">
						<table width="100%" cellpadding="4" cellspacing="0" border="0" align="center">
							<tr>
								<td><span class="textContent"><b><a href="n_detail.php?newsID=<? echo$row->player_id; ?>"><? echo$row->player_fname; ?> <? echo$row->player_lname; ?></a></b><br></span></td>
							</tr>
								<tr>
								<td>Written by  | </td>
							</tr>
						</table></td>
						<td align="center" valign="center"><img src="images/players/small/<? echo$row->player_id; ?>.jpg" alt="<? echo$row->player_fname; ?> <? echo$row->player_lname; ?>" border="1"></td>
					</tr>
				</table>
			</td>
		</tr>
	<?
		}

	if($page != 1){ 
		$pageprev = $page--;

	echo("<a href=\"$PHP_SELF&page=$pageprev\">PREV".$limit."</a> "); 
		}else{
			echo("PREV".$limit." ");
	}

	$numofpages = $totalrows / $limit; 

	for($i = 1; $i <= $numofpages; $i++){
		if($i == $page){
			echo($i." ");
		}else{
			echo("<a href=\"$PHP_SELF?page=$i\">$i</a> ");
		}
	}

	if(($totalrows % $limit) != 0){
		if($i == $page){
			echo($i." ");
		}else{
			echo("<a href=\"$PHP_SELF?page=$i\">$i</a> ");
		}
	}

	if(($totalrows - ($limit * $page)) > 0){
		$pagenext = $page++;

			echo("<a href=\"$PHP_SELF?page=$pagenext\">NEXT".$limit."</a>"); 
		}else{
			echo("NEXT".$limit); 
		}

	mysql_free_result($result);
?>