irti_h

@ PFMaBiSmAd still a long way to go i guess...hehe...ok am gonna start by getting all those select options from a table....switch on error reporting and find out how to use arrays......still if only i could get through this pagination............

Hi thanks a lot for the help...but the page is still coming up blank...i think its my lack of knowledge to blame...could you please have a look at the implementation of your code....thanks a lot I have changed result to result2 as I have a kind of backend for this site and i have used query and result as variables in that so I was afraid that these both could clash..So i have changed result to result2 and query to query2....and I have replaced my while loop in the area where you pointed out......Thanks a lot once again for helping me out <?php $result2 = mysql_query("SELECT * FROM articles WHERE cat = '2'") or trigger_error('Query failed: '. mysql_error()); $numrows = mysql_num_rows($result); $rowsperpage = 10; $totalpages = ceil($numrows / $rowsperpage); if (isset($_GET['page']) && is_numeric($_GET['page'])) { $currentpage = (int) $_GET['page'];} else { $currentpage = 1;} if ($currentpage > $totalpages) { $currentpage = $totalpages;} if ($currentpage < 1) { $currentpage = 1;} $offset = ($currentpage - 1) * $rowsperpage; $result2 = mysql_query("SELECT * FROM articles WHERE cat = '2' LIMIT $offset, $rowsperpage") or trigger_error('Query failed: '. mysql_error()); while ($row2 = mysql_fetch_array($result2)) { // WHAT SHOULD BE DISPLAYED. EXAMPLE; $img = $row2['img']; $img = stripslashes($img); $title = $row2['title']; $title = stripslashes($title); $desc = $row2['descr']; $desc = stripslashes($desc); $desc = substr($desc,0,2500); $id = $row2['id']; } echo 'Pages: '; $range = 3; if ($currentpage > 1) { echo " <a href='{$_SERVER['PHP_SELF']}?page=1'><<</a> "; $prevpage = $currentpage - 1; echo " <a href='{$_SERVER['PHP_SELF']}?page=$prevpage'><</a> ";} else{ echo " <a href='{$_SERVER['PHP_SELF']}?page=1'><<</a> "; $prevpage = $currentpage - 1; echo " <a href='{$_SERVER['PHP_SELF']}?page=1'><</a> ";} for ($x = ($currentpage - $range); $x < (($currentpage + $range) + 1); $x++) { if (($x > 0) && ($x <= $totalpages)) { if ($x == $currentpage) { echo " [<b>$x</b>] "; } else { echo " <a href='{$_SERVER['PHP_SELF']}?page=$x'>$x</a> "; } } } if ($currentpage != $totalpages) { $nextpage = $currentpage + 1; echo " <a href='{$_SERVER['PHP_SELF']}?page=$nextpage'>></a> "; echo " <a href='{$_SERVER['PHP_SELF']}?page=$totalpages'>>></a> <br /><br /><br />";} else{ echo " <a href='{$_SERVER['PHP_SELF']}?page=$totalpages'>></a> "; echo " <a href='{$_SERVER['PHP_SELF']}?page=$totalpages'>>></a> <br /><br /><br />";} ?>

Hi i tried the method above and i get the links but the links dont connect to anything and am still stuck with all the entries on my frontpage...am sorry but am new at this...thanks a lot for ypur help

Hi I wanted to implement pagination on a database driven website...Here is the code I wrote....I don't know whats wrong..Can anyone please help me with this.... <div style="text-align:left;margin-left:14px;"> <div class="crumb"><a href="index.php">Home - </a><b>Doctor's Profiles</b></div> <div class="text"><b>Choose Department:</b></div><br/> <table><tr> <td style="vertical-align:top;"> <form action="profiles.php" method="post"> <select name="dept"> <option value="0">All Doctors</option> <option value="1">Internal Medicine</option> <option value="2">Cardiology</option> <option value="3">Pediatrics</option> <option value="4">General Surgery</option> <option value="5">Orthopedics</option> <option value="6">Obstetrics & Gynecology</option> <option value="7">Anesthesiology & Intensive Care</option> <option value="8">Accident & Emergency</option> <option value="9">Ophthalmology</option> <option value="10">Dermatology</option> <option value="11">Otolaryngology (ENT)</option> <option value="12">Dental</option> <option value="13">Pathology</option> <option value="14">Radiology & Imaging</option> <option value="15">Rehabitilation & Physiotherapy</option> </select> <input type="submit" value="Sort"/> </form><br/> <?php include("includes/db.php"); mysql_connect($host,$username,$password); @mysql_select_db($database) or die( "Unable to select database"); if ($dept != "" and $dept == "0") { $srch = "Department"; $query2 = "SELECT * FROM articles WHERE cat='2' and descr LIKE '%$srch%' ORDER by id DESC"; } if ($dept != "" and $dept == "1") { $srch = "Internal Medicine"; $query2 = "SELECT * FROM articles WHERE cat='2' and descr LIKE '%$srch%' ORDER by id DESC"; } else if ($dept != "" and $dept == "2") { $srch = "Cardiology"; $query2 = "SELECT * FROM articles WHERE cat='2' and descr LIKE '%$srch%' ORDER by id DESC"; } else if ($dept != "" and $dept == "3") { $srch = "Pediatrics"; $query2 = "SELECT * FROM articles WHERE cat='2' and descr LIKE '%$srch%' ORDER by id DESC"; } else if ($dept != "" and $dept == "4") { $srch = "General Surgery"; $query2 = "SELECT * FROM articles WHERE cat='2' and descr LIKE '%$srch%' ORDER by id DESC"; } else if ($dept != "" and $dept == "5") { $srch = "Orthopedics"; $query2 = "SELECT * FROM articles WHERE cat='2' and descr LIKE '%$srch%' ORDER by id DESC"; } else if ($dept != "" and $dept == "6") { $srch = "Obstetrics & Gynecology"; $query2 = "SELECT * FROM articles WHERE cat='2' and descr LIKE '%$srch%' ORDER by id DESC"; } else if ($dept != "" and $dept == "7") { $srch = "Anesthesiology & Intensive Care"; $query2 = "SELECT * FROM articles WHERE cat='2' and descr LIKE '%$srch%' ORDER by id DESC"; } else if ($dept != "" and $dept == "8") { $srch = "Accident & Emergency"; $query2 = "SELECT * FROM articles WHERE cat='2' and descr LIKE '%$srch%' ORDER by id DESC"; } else if ($dept != "" and $dept == "9") { $srch = "Ophthalmology"; $query2 = "SELECT * FROM articles WHERE cat='2' and descr LIKE '%$srch%' ORDER by id DESC"; } else if ($dept != "" and $dept == "10") { $srch = "Dermatology"; $query2 = "SELECT * FROM articles WHERE cat='2' and descr LIKE '%$srch%' ORDER by id DESC"; } else if ($dept != "" and $dept == "11") { $srch = "Otolaryngology (ENT)"; $query2 = "SELECT * FROM articles WHERE cat='2' and descr LIKE '%$srch%' ORDER by id DESC"; } else if ($dept != "" and $dept == "12") { $srch = "Dental"; $query2 = "SELECT * FROM articles WHERE cat='2' and descr LIKE '%$srch%' ORDER by id DESC"; } else if ($dept != "" and $dept == "13") { $srch = "Pathology"; $query2 = "SELECT * FROM articles WHERE cat='2' and descr LIKE '%$srch%' ORDER by id DESC"; } else if ($dept != "" and $dept == "14") { $srch = "Radiology & Imaging"; $query2 = "SELECT * FROM articles WHERE cat='2' and descr LIKE '%$srch%' ORDER by id DESC"; } else if ($dept != "" and $dept == "15") { $srch = "Rehabitilation & Physiotherapy"; $query2 = "SELECT * FROM articles WHERE cat='2' and descr LIKE '%$srch%' ORDER by id DESC"; } else if ($dept != "" and $dept == "16") { $srch = "Orthopedics"; $query2 = "SELECT * FROM articles WHERE cat='2' and descr LIKE '%$srch%' ORDER by id DESC"; } else { /* First get total number of rows in data table. If you have a WHERE clause in your query, make sure you mirror it here. */ $query3 = "SELECT COUNT(*) FROM articles WHERE cat='2'"; $total_pages = mysql_fetch_array(mysql_query($query3)); $total_pages = $total_pages[num]; // How many adjacent pages should be shown on each side? $adjacents = 3; /* Setup vars for query. */ $targetpage = "profile1.php"; //your file name $limit = 10; //how many items to show per page $page = $_GET['page']; if($page) $start = ($page - 1) * $limit; //first item to display on this page else $start = 0; //if no page var is given, set start to 0 /* Get data. */ $query2 = "SELECT * FROM articles WHERE cat='2' ORDER by id ASC LIMIT $start, $limit"; /* Setup page vars for display. */ if ($page == 0) $page = 1; //if no page var is given, default to 1. $prev = $page - 1; //previous page is page - 1 $next = $page + 1; //next page is page + 1 $lastpage = ceil($total_pages/$limit); //lastpage is = total pages / items per page, rounded up. $lpm1 = $lastpage - 1; //last page minus 1 /* Now we apply our rules and draw the pagination object. We're actually saving the code to a variable in case we want to draw it more than once. */ $pagination = ""; if($lastpage > 1) { $pagination .= "<div class=\"pagination\">"; //previous button if ($page > 1) $pagination.= "<a href=\"$targetpage?page=$prev\">« previous</a>"; else $pagination.= "<span class=\"disabled\">« previous</span>"; //pages if ($lastpage < 7 + ($adjacents * 2)) //not enough pages to bother breaking it up { for ($counter = 1; $counter <= $lastpage; $counter++) { if ($counter == $page) $pagination.= "<span class=\"current\">$counter</span>"; else $pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>"; } } elseif($lastpage > 5 + ($adjacents * 2)) //enough pages to hide some { //close to beginning; only hide later pages if($page < 1 + ($adjacents * 2)) { for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++) { if ($counter == $page) $pagination.= "<span class=\"current\">$counter</span>"; else $pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>"; } $pagination.= "..."; $pagination.= "<a href=\"$targetpage?page=$lpm1\">$lpm1</a>"; $pagination.= "<a href=\"$targetpage?page=$lastpage\">$lastpage</a>"; } //in middle; hide some front and some back elseif($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2)) { $pagination.= "<a href=\"$targetpage?page=1\">1</a>"; $pagination.= "<a href=\"$targetpage?page=2\">2</a>"; $pagination.= "..."; for ($counter = $page - $adjacents; $counter <= $page + $adjacents; $counter++) { if ($counter == $page) $pagination.= "<span class=\"current\">$counter</span>"; else $pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>"; } $pagination.= "..."; $pagination.= "<a href=\"$targetpage?page=$lpm1\">$lpm1</a>"; $pagination.= "<a href=\"$targetpage?page=$lastpage\">$lastpage</a>"; } //close to end; only hide early pages else { $pagination.= "<a href=\"$targetpage?page=1\">1</a>"; $pagination.= "<a href=\"$targetpage?page=2\">2</a>"; $pagination.= "..."; for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter <= $lastpage; $counter++) { if ($counter == $page) $pagination.= "<span class=\"current\">$counter</span>"; else $pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>"; } } } //next button if ($page < $counter - 1) $pagination.= "<a href=\"$targetpage?page=$next\">next »</a>"; else $pagination.= "<span class=\"disabled\">next »</span>"; $pagination.= "</div>\n"; } ?> <?php $result2 = mysql_query($query2); mysql_close(); $ln = 0; while ($row2 = mysql_fetch_array($result2)) { $img = $row2['img']; $img = stripslashes($img); $title = $row2['title']; $title = stripslashes($title); $desc = $row2['descr']; $desc = stripslashes($desc); $desc = substr($desc,0,2500); $id = $row2['id']; ?> <?=$pagination?>