5 replies to this topic

[AFG89]

Hey

I have developed a new script for my site. i made pages using php and now i want to now to cut them, I mean, this is how it look " Pages: 1 2 3 4 5 6 7 8 9 10 Next". Anyone now how to make them look like this " Pages: 1 2 3 ... 8 9 10 Next".

Here is my php code:

<?
if (isset($_GET["type"])) {
 echo "<div class='border'><div class='m_header'>All  - Displayed by Most Recent</div></div>"; 
}
 ?>
 
 <?
 $conn=mysql_connect($dbhost, $dbuser, $dbpass);
 mysql_select_db($dbname) or die ("Unable to connect to MySQL");
 // print "Connected to MySQL"; </P> <P>
 $qresult = mysql_query("SELECT * FROM t_media WHERE m_type='".$_GET["type"]."' AND m_submapproved='Y'");
 
 $nrResults=mysql_num_rows($qresult);
 
 if (($nrResults%$allLimit)<>0) {
  $pmax=floor($nrResults/$myLimit)+1;
 } else {
  $pmax=floor($nrResults/$myLimit);
 }
 $qresult = mysql_query("SELECT * FROM t_media WHERE m_type='".$_GET["type"]."' AND m_submapproved='Y' ORDER BY m_id DESC LIMIT ".(($_GET["page"]-1)*$myLimit).", $myLimit");

 while ($line = mysql_fetch_assoc($qresult)){
?>

<? include("show.php"); ?>

<? } ?>


<div class='pages'>Page : <?=(($_GET["page"]<$pmax)?"<b><a href=\"/all/".$_GET["type"]."s/page".($_GET["page"]-1)."\" class=\"mediaTitle\">Previous</a>":"")?>
	  <?
		$pid=1;
		while ($pid<=$pmax) { ?>
			 <a href="/all/<?=$_GET["type"]?>s/page<?=$pid?>" class="page"> <?=$pid?></a> 
	   <? 
		$pid++;
	   } ?>
<?=(($_GET["page"]<$pmax)?"<b><a href=\"/all/".$_GET["type"]."s/page".($_GET["page"]+1)."\" class=\"mediaTitle\">Next</a>":"")?> <a href="/all/<?=$_GET["type"]?>s/page<?=$pmax?>" class="page"> Last</a> 
				   
   </div>

Any one know how do it ?

Edited by rc69, 02 September 2007 - 03:58 PM.

[Hayden]

yeah, what CI said.


the basic concept is that you only care to show the first and last 3-4 pages. that's where i would start if you already have the pagination setup

[stingerblue]

There is just the one tutorial on this: http://www.sampsonvi...PHP_Pagination/

[Braunson]

Their just regular windows media 9 codecs.
Mabe try re-installing your windows media player.

Windows Media Video 9 Screen Coded
Windows Media Audio Voice 9 20 kbps, 22.05 kHz, mono