Scott, can you just do it by sorting your query, then limiting the results to 10?
Advertising
ie. SELECT * FROM tables WHERE somthing='1' ORDER BY date DESC LIMIT 10 should sort highest -> lowest date (ie most recent, backwards) and give you the top 10 results. then if you have the option of flipping thru blocks of 10 results you can just change the last bit to LIMIT x,10 WHERE x is a starting point, then 10 obviously getting the next 10 entires. HTH Beau // -----Original Message----- // From: NIPP, SCOTT V (SBCSI) [mailto:[EMAIL PROTECTED]] // Sent: Wednesday, 14 August 2002 12:07 AM // To: '[EMAIL PROTECTED]' // Subject: [PHP-DB] Log Application Help... // // // I have a Log Application that is fully functional, but I need to // change a behavior and can't quite figure out how. This app // has three pages, // one for entering new entries, one to display all entries for // the last 5 // days, and the final page allows updating of existing // entries. The problem I // am having is that the log display page displays the data // ordered by date and // displays the oldest data first. I want the data ordered // this way, but I // would like it to default to the last page such that you see // the most recent // entry first. The log displays 10 entries per page, and I // just want it to // default to displaying the last page rather than the first. // Below is what I // think are the pertinent sections of code. Please let me // know what you // think, and if you need more information or code. Thanks in // advance for the // assistance. // // <?php require_once('prod.lib.php'); ?> // <?php // $currentPage = $HTTP_SERVER_VARS["PHP_SELF"]; // $maxRows_entry = 10; // $pageNum_entry = 0; // if (isset($HTTP_GET_VARS['pageNum_entry'])) { // $pageNum_entry = $HTTP_GET_VARS['pageNum_entry']; // } // $startRow_entry = $pageNum_entry * $maxRows_entry; // // mysql_select_db($database, $Prod); // $query_entry = "SELECT * FROM oncall WHERE TO_DAYS(NOW()) - // TO_DAYS(ptime) // <=5 ORDER BY 'ptime' ASC"; // $query_limit_entry = sprintf("%s LIMIT %d, %d", $query_entry, // $startRow_entry, $maxRows_entry); // $entry = mysql_query($query_limit_entry, $Prod) or // die(mysql_error()); // $row_entry = mysql_fetch_assoc($entry); // // if (isset($HTTP_GET_VARS['totalRows_entry'])) { // $totalRows_entry = $HTTP_GET_VARS['totalRows_entry']; // } else { // $all_entry = mysql_query($query_entry); // $totalRows_entry = mysql_num_rows($all_entry); // } // $totalPages_entry = ceil($totalRows_entry/$maxRows_entry)-1; // // $queryString_entry = ""; // if (!empty($HTTP_SERVER_VARS['QUERY_STRING'])) { // $params = explode("&", $HTTP_SERVER_VARS['QUERY_STRING']); // $newParams = array(); // foreach ($params as $param) { // if (stristr($param, "pageNum_entry") == false && // stristr($param, "totalRows_entry") == false) { // array_push($newParams, $param); // } // } // if (count($newParams) != 0) { // $queryString_entry = "&" . implode("&", $newParams); // } // } // $queryString_entry = sprintf("&totalRows_entry=%d%s", // $totalRows_entry, // $queryString_entry); // ?> // // ... A bunch of HTML formatting snipped out... // // <?php } while ($row_entry = mysql_fetch_assoc($entry)); ?> // </table>Records <?php echo ($startRow_entry + 1) ?> to <?php echo // min($startRow_entry + $maxRows_entry, $totalRows_entry) ?> // of <?php echo // $totalRows_entry ?> // <table border="0" width="50%" align="center"> // <tr> // <td width="23%" align="center"> <?php if ($pageNum_entry // > 0) { // Show // if not first page ?> // <a href="<?php printf("%s?pageNum_entry=%d%s", $currentPage, 0, // $queryString_entry); ?>">First</a> // <?php } // Show if not first page ?> </td> // <td width="31%" align="center"> <?php if ($pageNum_entry // > 0) { // Show // if not first page ?> // <a href="<?php printf("%s?pageNum_entry=%d%s", // $currentPage, max(0, // $pageNum_entry - 1), $queryString_entry); ?>">Previous</a> // <?php } // Show if not first page ?> </td> // <td width="23%" align="center"> <?php if ($pageNum_entry < // $totalPages_entry) { // Show if not last page ?> // <a href="<?php printf("%s?pageNum_entry=%d%s", $currentPage, // min($totalPages_entry, $pageNum_entry + 1), $queryString_entry); // ?>">Next</a> // <?php } // Show if not last page ?> </td> // <td width="23%" align="center"> <?php if ($pageNum_entry < // $totalPages_entry) { // Show if not last page ?> // <a href="<?php printf("%s?pageNum_entry=%d%s", $currentPage, // $totalPages_entry, $queryString_entry); ?>">Last</a> // <?php } // Show if not last page ?> </td> // </tr> // </table> // // ...Cut of the rest of the HTML junk... // // Scott Nipp // Phone: (214) 858-1289 // E-mail: [EMAIL PROTECTED] // Web: http:\\ldsa.sbcld.sbc.com // // // // -- // 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
