Alphabetical pagination help needed

[freshlight]

Hi folks

 

I am tiring to display large nos of database record alphabetically, my code doing it perfectly but the problem is that, there are hundreds of records for each alphabet and page going too long. so i'm tiring to control it by further pagination and i did it successfully but when i;m clicking on 2nd page it display nothing and redirects to hat alphabet page, here is what i have so far

 

<?php	
$alphabet = array('A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z');
foreach ($alphabet as $letter) {
echo "<a href=\"?letter=" . $letter . "\">" . $letter . "</a> ¦ ";
}
?>

<?php 
	require("config/config.php");
	require("config/connection.php");

$letter=$_GET['letter'];

//if(isset($letter)){



     $query = "SELECT COUNT(*) as num FROM tablename WHERE fieldname LIKE '$letter%'";
 $total_pages = mysql_fetch_array(mysql_query($query));
     include("pagination.php");
     $sql = "SELECT * FROM tablename WHERE fieldname LIKE '$letter%' LIMIT $start, $limit";  
     $result = mysql_query($sql);
     while($rows=mysql_fetch_array($result))
{	

	echo '<tr><td>'.$rows['fieldname'].'</td></tr>';
	}
//	}
	?>
	</table>
<?php echo $pagination; ?>

 

   

pls help me on his guys. thanks

 

[Adam]

Heh, would help if we could see the pagination code...

 

include("pagination.php");

[freshlight]

MrAdam, here is the pagination code

 

 

<?php

//$tbl_name="directrylist";		//your table name
// How many adjacent pages should be shown on each side?
$adjacents = 3;

/* 
   First get total number of rows in data table. 
   If you have a WHERE clause in your query, make sure you mirror it here.
*/

$total_pages = $total_pages[num];
//echo $total_pages;

/* Setup vars for query. */
//$targetpage = "view.php"; 	//your file name  (the name of this file)
$limit = 100; 								//how many items to show per page
$page = $_GET['page'];
if($page) 
	$start = ($page - 1) * $limit; 			//first item to display on this page
else
	$start = 0;								//if no page var is given, set start to 0

/* Get data. */
    

/* Setup page vars for display. */
if ($page == 0) $page = 1;					//if no page var is given, default to 1.
$prev = $page - 1;							//previous page is page - 1
$next = $page + 1;							//next page is page + 1
$lastpage = ceil($total_pages/$limit);		//lastpage is = total pages / items per page, rounded up.
$lpm1 = $lastpage - 1;						//last page minus 1

/* 
	Now we apply our rules and draw the pagination object. 
	We're actually saving the code to a variable in case we want to draw it more than once.
*/
$pagination = "";
if($lastpage > 1)
{	
	$pagination .= "<div class=\"pagination\">";
	//previous button
	if ($page > 1) 
		$pagination.= "<a href=\"$targetpage?page=$prev\">« previous</a>";
	else
		$pagination.= "<span class=\"disabled\">« previous</span>";	

	//pages	
	if ($lastpage < 7 + ($adjacents * 2))	//not enough pages to bother breaking it up
	{	
		for ($counter = 1; $counter <= $lastpage; $counter++)
		{
			if ($counter == $page)
				$pagination.= "<span class=\"current\">$counter</span>";
			else
				$pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>";					
		}
	}
	elseif($lastpage > 5 + ($adjacents * 2))	//enough pages to hide some
	{
		//close to beginning; only hide later pages
		if($page < 1 + ($adjacents * 2))		
		{
			for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++)
			{
				if ($counter == $page)
					$pagination.= "<span class=\"current\">$counter</span>";
				else
					$pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>";					
			}
			$pagination.= "...";
			$pagination.= "<a href=\"$targetpage?page=$lpm1\">$lpm1</a>";
			$pagination.= "<a href=\"$targetpage?page=$lastpage\">$lastpage</a>";		
		}
		//in middle; hide some front and some back
		elseif($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2))
		{
			$pagination.= "<a href=\"$targetpage?page=1\">1</a>";
			$pagination.= "<a href=\"$targetpage?page=2\">2</a>";
			$pagination.= "...";
			for ($counter = $page - $adjacents; $counter <= $page + $adjacents; $counter++)
			{
				if ($counter == $page)
					$pagination.= "<span class=\"current\">$counter</span>";
				else
					$pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>";					
			}
			$pagination.= "...";
			$pagination.= "<a href=\"$targetpage?page=$lpm1\">$lpm1</a>";
			$pagination.= "<a href=\"$targetpage?page=$lastpage\">$lastpage</a>";		
		}
		//close to end; only hide early pages
		else
		{
			$pagination.= "<a href=\"$targetpage?page=1\">1</a>";
			$pagination.= "<a href=\"$targetpage?page=2\">2</a>";
			$pagination.= "...";
			for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter <= $lastpage; $counter++)
			{
				if ($counter == $page)
					$pagination.= "<span class=\"current\">$counter</span>";
				else
					$pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>";					
			}
		}
	}

	//next button
	if ($page < $counter - 1) 
		$pagination.= "<a href=\"$targetpage?page=$next\">next »</a>";
	else
		$pagination.= "<span class=\"disabled\">next »</span>";
	$pagination.= "</div>\n";		
}
?>
                                     <?php echo $pagination?>

 

 

[freshlight]

Will anyone help me on this pls??

[The PHP Guy]

Try:

<?php	
$alphabet = array('A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z');
foreach ($alphabet as $letter) {
//The PHP Guy changed ?letter= to ?page=
echo "<a href=\"?page=" . $letter . "\">" . $letter . "</a> ¦ ";
}
?>

<?php 
	require("config/config.php");
	require("config/connection.php");

//The PHP Guy changed $_GET['letter'] to $_GET['page']
$letter=$_GET['page'];

//if(isset($letter)){



     $query = "SELECT COUNT(*) as num FROM tablename WHERE fieldname LIKE '$letter%'";
 $total_pages = mysql_fetch_array(mysql_query($query));
     include("pagination.php");
     $sql = "SELECT * FROM tablename WHERE fieldname LIKE '$letter%' LIMIT $start, $limit";  
     $result = mysql_query($sql);
     while($rows=mysql_fetch_array($result))
{	

	echo '<tr><td>'.$rows['fieldname'].'</td></tr>';
	}
//	}
	?>
	</table>
<?php echo $pagination; ?>