Evilace

any ideas? this has been bugging me for ages, i just dont understand why its not updating the page number when you delete a report, it works ok apart from that

if ($uri == '/products.php?ptid=5') { $class-name = "class"; ......etc } put alternate clause for pages greater than you want if ($uri > '/products.php?ptid=5') { echo"invalid"; } just play with it, maybe it will help

i could use some help really, basically i have a page that displays reports, i have added page numbers to split the results to multiple pages, eveything is ok however when i delete a report/log which is another script that deletes it, all that works however it does not update the page numbers properly once you have deleted all the reports on that page, so say you have one page that is empty and one that has reports in, but the other still shows instead of just saying page 1 of 1, it still lets you view all the other pages that were recorded but display blank, ie Showing page 1 of 5 pages [Next] [Last Page] here is the page script in the file $rowsPerPage = 10; $pageNum = 1; if(isset($_GET['page'])) { $pageNum = $_GET['page']; } $offset = ($pageNum - 1) * $rowsPerPage; $res = $db->query("SELECT * FROM ".$gameid."_battlereports WHERE attacked='$playerid' OR attacker='$playerid' ORDER BY id DESC LIMIT $offset, $rowsPerPage"); $count = $db->query("SELECT COUNT(id) AS numrows FROM ".$gameid."_battlereports WHERE attacked='$playerid' OR attacker='$playerid'"); $row = mysql_fetch_assoc($count); $numrows = $row['numrows']; $maxPage = ceil($numrows/$rowsPerPage); $self = $_SERVER['PHP_SELF']; $nav = ''; for($page = 1; $page <= $maxPage; $page++) { if ($page == $pageNum) { $nav .= " $page "; } else { $nav .= " <a href='$self?act=$brpt_a&game=t&page=$page'>$page</a> "; } } if ($pageNum > 1) { $page = $pageNum - 1 ; $prev = " <a href='$self?act=$brpt_a&game=t&page=$page'>[Prev]</a> "; $first = " <a href='$self?act=$brpt_a&game=t&page=1'>[First Page]</a> "; } else { $prev = ' '; $first = ' '; } if ($pageNum < $maxPage) { $page = $pageNum + 1; $next = " <a href='$self?act=$brpt_a&game=t&page=$page'>[Next]</a> "; $last = " <a href='$self?act=$brpt_a&game=t&page=$maxPage'>[Last Page]</a> "; } else { $next = ' '; $last = ' '; } // Output goes here so much im not posting it echo "<center><br />".$first."".$prev." Showing page ".$pageNum." of ".$maxPage." pages ".$next."".$last."</center>"; if you need any more info please say, any help appretitated

try these, i made one from this google phpbb or http://www.phpbb.com/

<?php echo "<font face='verdana'><br />" $db = mysql_connect("localhost", "", "") or die("Connection Failed"); mysql_select_db("") or die("Database Failed"); $query = "SELECT id, date_created FROM ap_form_1, ap_element_options WHERE (ap_form_1.id = ap_element_options.form_id) ORDER BY date_created DESC"; $result = mysql_query($query) or die("Query Failed"); while($row = mysql_fetch_array($result)){ echo "<br />ID: ".$row['id']." Date Volunteered: ".$row['date_created'].""; } ?> Try that?