Adding "Pages" from query.

[u214]

So I would like to know how to make pages?

 

Let's say I have a query: SELECT * FROM test ORDER BY testid ASC

So if the table "test" has 100 rows, how can I make below the results, pages: 1 - 10.

 

Hope y'all get what I mean. Thanks!

[YoungNate_Black_coder]

walk in the park ...........

<?php do { ?> 
<a href="page.php?whateveruwant=<?php echo $row_page['id']; ?>">page titles (use a row value for this as well)</a>
  <?php
} while ($row_page = mysql_fetch_assoc($what ever u used as your query identifire ));
  $rows = mysql_num_rows($row_page);
  if($rows > 0) {
      mysql_data_seek($what ever u used as your query identifire, 0);
  $row_males = mysql_fetch_assoc($what ever u used as your query identifire);
  }
?>

 

////////////

[HDFilmMaker2112]

This is the script I used:

 

http://www.phpeasystep.com/phptu/29.html

 

Example:

http://www.GhostHuntersPortal.com/store.php?cat=emf-meters&num_products=8

[AMcHarg]

It's worth your while reading about the MYSQL LIMIT syntax.

 

Example:

 

LIMIT $start_record, $number_of_records_per_page

 

So if you have 100 records and want 10 per page then to show page 5 it would be something like:

 

$start_record = 50;

$number_of_records_per_page = 10;

 

LIMIT $start_record, $number_of_records_per_page