Look at: http://www.phpclasses.org/browse/package/92.html
It's a pager class that does: << Previous 1 2 3 4 5 6 7 8 9 10 Next >> Gary Every Sr. UNIX Administrator Ingram Entertainment Inc. 2 Ingram Blvd, La Vergne, TN 37089 "Pay It Forward!" -----Original Message----- From: Kpromos [mailto:[EMAIL PROTECTED] Sent: Thursday, May 20, 2004 8:35 AM To: [EMAIL PROTECTED] Subject: [PHP-DB] Display mysql query results divided in dynamic numbered pages Importance: High Dears, I'm new to php, so I'm not able to solve the following problem. I have a function with a while loop that generates the results of a mysql query. I'd need to generate a flow of the results, divided in pages as ... <Previous> 1 2 3 4 <Next> ... The function I'm using follows .. and also the script that should generate the numbered pages. Someone could help me in incorporating the script that follows too? ===== function displaying the results ====== function display($show_what) { switch ($show_what) { case "": $sql = "select * from news2 ORDER BY date DESC, time DESC"; break; } display_posts($sql); } function display_posts($sql) { connect(); $result = mysql_query($sql) or die(mysql_error()); ?> <table width="100%" border="0" cellpadding="5" align="CENTER"> <tr> <td> <hr align="RIGHT" size="1" width="100%" noshade> </td> </tr> <? while($row = mysql_fetch_array($result)) { ?> <tr><td> <? if($last_date == $row["date"]):?> <p class="date"><b><?echo $row["time"]?></b> <?else:?> <p class="date"><?echo $row["time"]?> - <b><?echo $row["date"]?></b> <?endif; $cat_num = $row["category_id"]; $cat_result = mysql_query("select categories.category from news2, categories where news2.category_id = categories.category_id and news2.category_id = '$cat_num'"); $cat = mysql_fetch_array($cat_result); ?> <br> ................ .......... </tr> <? } ?> </table> <? } === script for generating the pages === $table = 'news2'; // The name of your table in the database $limit = '2'; // How many results should be shown at a time $scroll = '10'; // How many elements to the navigation bar are shown at a time // Get the total number of rows in a database $query1 = mysql_query ("SELECT * FROM news2"); $numrows = mysql_num_rows ($query1); // if (!isset ($_GET[show])) { $display = 1; // Change to $NUMROWS if DESCENDING order is required } else { $display = $_GET[show]; } // Return results from START to LIMIT $start = (($display * $limit) - $limit); $query2 = mysql_query ("SELECT * FROM $table LIMIT $start,$limit"); while ($myrow = mysql_fetch_array ($query2)) { echo "<p>".$myrow[ROW]."</p>"; // EDIT TO REFLECT YOUR RESULTS } // $paging = ceil ($numrows / $limit); // Display the navigation if ($display > 1) { $previous = $display - 1; echo "<a href=\"$_SERVER[PHP_SELF]?show=1\"><< First</a> | "; echo "<a href=\"$_SERVER[PHP_SELF]?show=$previous\">< Previous</a> | "; } if ($numrows != $limit) { if ($paging > $scroll) { $first = $_GET[show]; $last = ($scroll - 1) + $_GET[show]; } else { $first = 1; $last = $paging; } if ($last > $paging ) { $first = $paging - ($scroll - 1); $last = $paging; } for ($i = $first;$i <= $last;$i++){ if ($display == $i) { echo "<b>$i</b> "; } else { echo "<a href=\"$_SERVER[PHP_SELF]?show=$i\">$i</a> "; } } } if ($display < $paging) { $next = $display + 1; echo "| <a href=\"$_SERVER[PHP_SELF]?show=$next\">Next ></a> | "; echo "<a href=\"$_SERVER[PHP_SELF]?show=$numrows\">Last >></a>"; } // ?> Thanks for all, Alessandro Folghera -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
