Displaying Pages: 1 2 3 4 5 ...

[keikogal]

can anyone tell me how do I go about changing the Next 15 >> and << Prev 15 links to Pages: 1 2 3 4 5 and so on? And if possible, how do I make it such that the Pages: 1 2 3 4 5 and so on are listed just above and below all my results?

Here's part of my code:

<center><br><br><font face=arial size=2>Your search returned <b><?php echo

"$numrows";?></b> result(s)</center>

<?php

// begin to show results set
echo "<br><p>";
$count = 1 + $s ;

// now you can display the results returned
while ($row= mysql_fetch_array($result)) {
?>
<table border=1 bordercolor=#CCCCCC cellpadding=0 cellspacing=0 width=95%>
<tr bgcolor=#EEEEEE>
<td colspan=1 height=18>&nbsp;<b>ID #:</b>&nbsp;<?php echo

$row["id"];?></td><td colspan=3 height=18 align=right><b>Status:</b>&nbsp;<?php

echo $row["status"];?>&nbsp;</td>
</tr>
<tr>
<td align=left><p><font color=navy>May begin breeding as of&nbsp;<?php echo

$row["Year_Breed"];?>&nbsp;and must retire at&nbsp;<?php echo

$row["Year_Stop"];?></font><br><br>Vet: &nbsp;<?php echo

$row["vet"];?>&nbsp;<br>Shod:&nbsp;<?php echo $row["shod"];?>&nbsp;<br>Other:

Nil<br></td>
<td bgcolor=#FFFFFF width=64%><p><B><font size=2>
<?php echo $row["name"];?></font></B><br>
<?php echo $row["age"];?>&nbsp;<?php echo $row["color"];?>&nbsp;<?php echo

$row["breed"];?>&nbsp;<?php echo $row["gender"];?><br><br>
<b>Sire:</b>&nbsp;<?php echo $row["sire"];?>&nbsp;<?php echo

$row["sireid"];?><br>
<b>Dam:</b>&nbsp;<?php echo $row["dam"];?>&nbsp;<?php echo

$row["damid"];?><br><br>
<b>Discipline:</b><br><?php echo $row["disipline"];?><br><br>
<b>Owner:</b><br><?php echo $row["owner"];?></td>
</tr>
</table><br>
<?php

$count++ ;
}

$currPage = (($s/$limit) + 1);

// next we need to do the links to other results
if ($s>=1) { // bypass PREV link if s is 0
$prevs=($s-$limit);
print "&nbsp;<a

href=\"$PHP_SELF?s=$prevs&id=$var&name=$var2&age=$var3&color=$var4&breed=$var5&g

ender=$var6&status=$var7&owner=$var8&hs=$var9&vet=$var12\"><font face=verdana

size=1>&lt;&lt;
Prev 15</font></a>&nbsp&nbsp;";
}

// calculate number of pages needing links
$pages=intval($numrows/$limit);

// $pages now contains int of pages needed unless there is a remainder from

division

if ($numrows%$limit) {
// has remainder so add one page
$pages++;
}

// check to see if last page
if (!((($s+$limit)/$limit)==$pages) && $pages!=1) {

// not last page so give NEXT link
$news=$s+$limit;

echo "&nbsp;<a

href=\"$PHP_SELF?s=$news&id=$var&name=$var2&age=$var3&color=$var4&breed=$var5&ge

nder=$var6&status=$var7&owner=$var8&hs=$var9&vet=$var12\"><font face=verdana

size=1>Next 15 &gt;&gt;</font></a>";
}

echo "</div>
</td>
</tr>
</table>
</body>
</html>";
exit;
}

[vaska]

there is a brilliant thread on display pages at the top of this page in one of the stickied threads up there...you can't miss it if you dig around up there...it's worthy reading...

sorry, don't have any other advice for you otherwise...

good luck...v

[tekky]

some advice... use

 tag's around your PHP not [QUOTE] tags

[ucbones]

here ya go

http://www.phpbuilder.com/board/showthread.php?s=&threadid=10234923

ucbones

[keikogal]

Thank You! It helped. 😉