Spacing Problem in table when using Paging...!

  • asad_black
  • Graduate
  • Graduate
  • asad_black
  • Posts: 131
  • Loc: pakistan

Post 3+ Months Ago

hi,
i have problem in following page:

http://jugnoo.tv/category_activity.php
you will see on the first page with correct format of table without any spacing..!

now when click on the last from paging http://jugnoo.tv/category_activity.php?currentpage=4&q=

it shows blank space in the image coloum...!

i dont know whatz de problem..!

this is my code:
Code: [ Select ]
<td bgcolor="#FF9900"><div align="center"><span class="heading_of_ctg">Activities</span><br>
<br>
</div>
<?php

// database connection info
$conn = mysql_connect('localhost','sample','sample') or trigger_error("SQL", E_USER_ERROR);
$db = mysql_select_db('sample',$conn) or trigger_error("SQL", E_USER_ERROR);

// find out how many rows are in the table
$sql = "SELECT COUNT(*) FROM links where ctg='activity'";
$result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);
$r = mysql_fetch_row($result);
$numrows = $r[0];

// number of rows to show per page
$rowsperpage = 10;
// find out total pages
$totalpages = ceil($numrows / $rowsperpage);

// get the current page or set a default
if (isset($_GET['currentpage']) && is_numeric($_GET['currentpage'])) {
// cast var as int
$currentpage = (int) $_GET['currentpage'];
} else {
// default page num
$currentpage = 1;
} // end if

// if current page is greater than total pages...
if ($currentpage > $totalpages) {
// set current page to last page
$currentpage = $totalpages;
} // end if
// if current page is less than first page...
if ($currentpage < 1) {
// set current page to first page
$currentpage = 1;
} // end if

// the offset of the list, based on current page
$offset = ($currentpage - 1) * $rowsperpage;

// get the info from the db
$sql = "SELECT * FROM links where ctg='activity'
LIMIT $offset, $rowsperpage";
$result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);

echo "<table border='1' cellpadding='3' cellspacing='3' width='60%'>";
// while there are rows to be fetched...
while ($list = mysql_fetch_assoc($result)) {
// echo data
{
echo "<tr>";
echo "<td valign=top><a href=\"idpage.php?id=" . $list["id"] . "\"><img src=\"" . $list["image"] . "\" height='80' width='80' border=2 style='border-color:#E20A17;'></a></td>";
echo "<td valign=top class=picclick><a href=\"idpage.php?id=" . $list["id"] . "\">". $list['text']. "</a><br><span class=descriptiontext>".$list['des']."</span>";
echo "</td>";
echo "</tr>";
}
}
//echo "</tr>";

/****** build the pagination links ******/
// range of num links to show
echo"<tr>";
echo"<td colspan='2'>";
$range = 3;

// if not on page 1, don't show back links
if ($currentpage > 1) {
echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=1&q=$var'>First</a> ";
// get previous page num
$prevpage = $currentpage - 1;
// show < link to go back to 1 page
echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$prevpage&q=$var'>Previous</a>";
} // end if

// loop to show links to range of pages around current page
for ($x = ($currentpage - $range); $x < (($currentpage + $range) + 1); $x++) {
// if it's a valid page number...
if (($x > 0) && ($x <= $totalpages)) {
// if we're on current page...
if ($x == $currentpage) {
// 'highlight' it but don't make a link
echo " [<b>$x</b>] ";
// if not current page...
} else {
// make it a link
echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$x&q=$var'>$x</a> ";
} // end else
} // end if
} // end for

// if not on last page, show forward and last page links
if ($currentpage != $totalpages) {
// get next page
$nextpage = $currentpage + 1;
// echo forward link for next page
echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$nextpage&q=$var'>Next</a> ";
// echo forward link for lastpage
echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$totalpages&q=$var'>Last</a> ";
} // end if
/****** end build pagination links ******/
echo "</td>";
echo "</tr>";
echo "</table>";
?></td>
</tr>
</table>
  1. <td bgcolor="#FF9900"><div align="center"><span class="heading_of_ctg">Activities</span><br>
  2. <br>
  3. </div>
  4. <?php
  5. // database connection info
  6. $conn = mysql_connect('localhost','sample','sample') or trigger_error("SQL", E_USER_ERROR);
  7. $db = mysql_select_db('sample',$conn) or trigger_error("SQL", E_USER_ERROR);
  8. // find out how many rows are in the table
  9. $sql = "SELECT COUNT(*) FROM links where ctg='activity'";
  10. $result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);
  11. $r = mysql_fetch_row($result);
  12. $numrows = $r[0];
  13. // number of rows to show per page
  14. $rowsperpage = 10;
  15. // find out total pages
  16. $totalpages = ceil($numrows / $rowsperpage);
  17. // get the current page or set a default
  18. if (isset($_GET['currentpage']) && is_numeric($_GET['currentpage'])) {
  19. // cast var as int
  20. $currentpage = (int) $_GET['currentpage'];
  21. } else {
  22. // default page num
  23. $currentpage = 1;
  24. } // end if
  25. // if current page is greater than total pages...
  26. if ($currentpage > $totalpages) {
  27. // set current page to last page
  28. $currentpage = $totalpages;
  29. } // end if
  30. // if current page is less than first page...
  31. if ($currentpage < 1) {
  32. // set current page to first page
  33. $currentpage = 1;
  34. } // end if
  35. // the offset of the list, based on current page
  36. $offset = ($currentpage - 1) * $rowsperpage;
  37. // get the info from the db
  38. $sql = "SELECT * FROM links where ctg='activity'
  39. LIMIT $offset, $rowsperpage";
  40. $result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);
  41. echo "<table border='1' cellpadding='3' cellspacing='3' width='60%'>";
  42. // while there are rows to be fetched...
  43. while ($list = mysql_fetch_assoc($result)) {
  44. // echo data
  45. {
  46. echo "<tr>";
  47. echo "<td valign=top><a href=\"idpage.php?id=" . $list["id"] . "\"><img src=\"" . $list["image"] . "\" height='80' width='80' border=2 style='border-color:#E20A17;'></a></td>";
  48. echo "<td valign=top class=picclick><a href=\"idpage.php?id=" . $list["id"] . "\">". $list['text']. "</a><br><span class=descriptiontext>".$list['des']."</span>";
  49. echo "</td>";
  50. echo "</tr>";
  51. }
  52. }
  53. //echo "</tr>";
  54. /****** build the pagination links ******/
  55. // range of num links to show
  56. echo"<tr>";
  57. echo"<td colspan='2'>";
  58. $range = 3;
  59. // if not on page 1, don't show back links
  60. if ($currentpage > 1) {
  61. echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=1&q=$var'>First</a> ";
  62. // get previous page num
  63. $prevpage = $currentpage - 1;
  64. // show < link to go back to 1 page
  65. echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$prevpage&q=$var'>Previous</a>";
  66. } // end if
  67. // loop to show links to range of pages around current page
  68. for ($x = ($currentpage - $range); $x < (($currentpage + $range) + 1); $x++) {
  69. // if it's a valid page number...
  70. if (($x > 0) && ($x <= $totalpages)) {
  71. // if we're on current page...
  72. if ($x == $currentpage) {
  73. // 'highlight' it but don't make a link
  74. echo " [<b>$x</b>] ";
  75. // if not current page...
  76. } else {
  77. // make it a link
  78. echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$x&q=$var'>$x</a> ";
  79. } // end else
  80. } // end if
  81. } // end for
  82. // if not on last page, show forward and last page links
  83. if ($currentpage != $totalpages) {
  84. // get next page
  85. $nextpage = $currentpage + 1;
  86. // echo forward link for next page
  87. echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$nextpage&q=$var'>Next</a> ";
  88. // echo forward link for lastpage
  89. echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$totalpages&q=$var'>Last</a> ";
  90. } // end if
  91. /****** end build pagination links ******/
  92. echo "</td>";
  93. echo "</tr>";
  94. echo "</table>";
  95. ?></td>
  96. </tr>
  97. </table>
  • Anonymous
  • Bot
  • No Avatar
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post 3+ Months Ago

  • Bogey
  • Genius
  • Genius
  • Bogey
  • Posts: 8388
  • Loc: USA

Post 3+ Months Ago

I don't see anything wrong on your site... I clicked the last page thing and I saw all the images and everything looked like the first page... just that there were less results, but I'm sure that that's ok.
  • devilwood
  • Silver Member
  • Silver Member
  • User avatar
  • Posts: 436

Post 3+ Months Ago

All the paged pages looked the same for me too. Maybe you fixed it?

IE 7+ and Firefox 3+
  • asad_black
  • Graduate
  • Graduate
  • asad_black
  • Posts: 131
  • Loc: pakistan

Post 3+ Months Ago

thankx for reply my problem has been solved by define the width of the image cell...!

Post Information

  • Total Posts in this topic: 4 posts
  • Users browsing this forum: ScottG and 119 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
 

© 1998-2014. Ozzu® is a registered trademark of Unmelted, LLC.