Help Php page numbering

Discussion in 'PHP' started by didobs, Mar 18, 2010.

0
  1. #1
    Hellow php masters !
    I need help to Number my results from SQL in table.I want to do it in pages..
    thanks
    

$query = mysql_query("SELECT  `id` , `username`,`point`   FROM `jos_users` ORDER BY `point` DESC")or die(mysql_error());

while ($row = mysql_fetch_array($query)) {

?>
<table border="0" width="90%" >
  <tr>
     <th width="568" scope="username"><b><a href="http://pechelish.com/vote.php?id=<? echo  $row['id'] ?>"><? echo  $row['username'] ?></a> </b></th>
     <th width="169" scope="point"><b> <? echo $row['point'] ?></b> points</th>
  </tr>
</table>
<? }
    PHP:

     
    didobs, Mar 18, 2010 IP
  2. danx10

    danx10 Peon

    Messages:
    1,179
    Likes Received:
    44
    Best Answers:
    2
    Trophy Points:
    0
    #2
    Read up on php/mysql pagination, I'm sure they'll be quite alot of examples/tutorials out their, if you do a search via google.
     
    danx10, Mar 18, 2010 IP
  3. guardian999

    guardian999 Well-Known Member

    Messages:
    376
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    103
    #3
    yes, try css paging
     
    guardian999, Mar 18, 2010 IP