11Tami Posted September 21, 2007 Share Posted September 21, 2007 Hello, here's some pagination code and my question below it. <?php mysql_connect('', '', '') or die(mysql_error()); mysql_select_db("") or die(mysql_error()); if(!isset($_GET['page'])){ $page = 1; } else { $page = $_GET['page']; } //pulls results from database $max_results = 10; $total_results = mysql_result(mysql_query("SELECT COUNT(id) FROM business"),0); //name of query web pages is page $total_pages = ceil($total_results / $max_results);$page = (int)$_GET['page']; $from = (($page * $max_results) - $max_results); $data = mysql_query("SELECT image, url, webname, description FROM business ORDER BY id ASC LIMIT $from, $max_results") or die(mysql_error()); while ($info = mysql_fetch_array($data)) { Print $info['Name']; echo "<p><a style='font-weight: bold; color: rgb(0, 0, 140); font-size: 14px;' href='$info[url]' target='_blank'>$info[webname]</a> <span style='font-size: 14px; font-family: arial,sans-serif; padding-right: 3px;'>$info[description]</span></p>"; } //show current and previous page numbers echo "<br /><br /><span style='margin-left:20px'></span>"; if($page > 1){ $prev = ($page - 1); echo " <a style='color: rgb(0, 0, 128)' href=\"".$_SERVER['PHP_SELF']."?page=$prev\">Previous<<</a> "; } for($i = 1; $i <= $total_pages; $i++){ if(($page) == $i){ echo "<span style='color: rgb(138, 0, 0);font-weight:bold'>$i </span>"; } else { echo "<a style='color: rgb(0, 0, 128)' href=\"".$_SERVER['PHP_SELF']."?page=$i\">$i</a> "; } } // build next links if($page < $total_pages){ $next = ($page + 1); echo " <a style='color: rgb(0, 0, 128)' href=\"".$_SERVER['PHP_SELF']."?page=$next\">Next>></a>"; } ?> When the first page is loaded or any links with this name like http://www.awebsite.com/business.php?page=1 Then it shows the results for a whole page for the first page, and lists the numbers for the other pages for people to click on or not. The problem I am having is the search engines are also showing this page. http://www.awebsite.com/business.php and I don't know why. I have no links going to that page but the search engines are finding it automatically anyway. But when people go to that page http://www.awebsite.com/business.php All it shows is page numbers only and no content. Is there anything I can change in this pagination so that the lowest page found is not http://www.awebsite.com/business.php but http://www.awebsite.com/business.php?page=1 instead? Please let me know, thanks. Quote Link to comment https://forums.phpfreaks.com/topic/70099-linking-paginate/ Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.