Ad:

PHP Discussion Thread
Unsolved
Views: 82

Aug 13th, 2010

Automatic Pages from While Loop

Expand Post »

Hello everyone.

I currently have a while loop that pulls all members to a page if the username begins with the selected letter. We have a lot of members now and the "usernames beginning with "a" are quite alot. So i need to be able to have a way to LIMIT to about 20 usernames then add a "new page" at the bottom. e.g i want like this at the bottom:

Page: 1 - 2 - 3 - 4 - 5 - 6, etc

And these are linked to the same page so the php code can list the next 20 members...

Here is my code at the minute and thank you very much in advance:

php Syntax (Toggle Plain Text)
 
<?php
$letter = $_GET['sort'];
if(!isset($letter)) {
$letter = "a";
}
$lettercombo = "$letter%";
$select = mysql_query("SELECT * FROM users WHERE username LIKE '$lettercombo' ORDER by username");
while($fetch = mysql_fetch_array($select)) {
?>
 
  <tr>
   <td><a style="color:#5b9600; font-weight:bold; text-shadow:0px 1px 0px #fff;" href="viewuser.php?user=<? echo $fetch['username']; ?>"><? echo $fetch['username']; ?></a></td>
   <td><? echo $fetch['gamertag']; ?></td>
   <td><? echo $fetch['joined']; ?></td>
  </tr>
 
<? } ?>
<?php
$letter = $_GET['sort'];
if(!isset($letter)) {
$letter = "a";
}
$lettercombo = "$letter%";
$select = mysql_query("SELECT * FROM users WHERE username LIKE '$lettercombo' ORDER by username");
while($fetch = mysql_fetch_array($select)) {
?>
  
  <tr>
   <td><a style="color:#5b9600; font-weight:bold; text-shadow:0px 1px 0px #fff;" href="viewuser.php?user=<? echo $fetch['username']; ?>"><? echo $fetch['username']; ?></a></td>
   <td><? echo $fetch['gamertag']; ?></td>
   <td><? echo $fetch['joined']; ?></td>
  </tr>
 
<? } ?>

Last edited by BlueCharge; Aug 13th, 2010 at 8:07 am.

Similar Threads

display query results with next button in PHP
PHP / SQL update database issue in PHP
How do I put continuous music in a php site? in PHP
document.getElementById problem in JavaScript / DHTML / AJAX
printing jsp pages without presenting them in JSP

BlueCharge

Reputation Points: 10

Solved Threads: 1

Light Poster

Offline

42 posts
since Jan 2010

Permalink

Aug 13th, 2010

Re: Automatic Pages from While Loop

why dont you retrieve the contents of the while loop into an array and check if its greater than the limit 20.

Last edited by anony; Aug 13th, 2010 at 9:21 am.

anony

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

20 posts
since Jun 2010

Permalink

Aug 13th, 2010

Re: Automatic Pages from While Loop

use queries like this
$res="mysql_query("SELECT * FROM users WHERE username LIKE '$lettercombo' ORDER by username");
$num=mysql_num_rows($res);
$limit=0;
$select = mysql_query("SELECT * FROM users WHERE username LIKE '$lettercombo' ORDER by username limit $limit-20");
while($fetch = mysql_fetch_array($select)) {

?>

<tr>
<td><a style="color:#5b9600; font-weight:bold; text-shadow:0px 1px 0px fff;" href="viewuser.php?user=<? echo $fetch['username']; ?>"><? echo $fetch['username']; ?></a></td>
<td><? echo $fetch['gamertag']; ?></td>

<td><? echo $fetch['joined']; ?></td>

</tr>

<? $limit+=20} ?>

Karthik.gautham

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

17 posts
since Aug 2010

Permalink

Aug 13th, 2010

Re: Automatic Pages from While Loop

http://www.google.com/cse?cx=partner...cocodle.com%2F

rajarajan07

Reputation Points: 167

Solved Threads: 239

Nearly a Posting Virtuoso

Offline

1,445 posts
since May 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: Need Help Travelling up a Relational Tree

Next Thread in PHP Forum Timeline: explode url and explode array.......

DaniWeb Message

Cancel Changes

User Name
Password