Spacing Problem in table when using Paging...!

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
asad_black
Forum Newbie
Posts: 20
Joined: Wed Feb 11, 2009 1:59 am

Spacing Problem in table when using Paging...!

Post by asad_black »

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:
<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>
user333
Forum Newbie
Posts: 8
Joined: Tue Mar 03, 2009 12:02 pm

Re: Spacing Problem in table when using Paging...!

Post by user333 »

What is that blank space? Excuse me but I can not find it out.
User avatar
susrisha
Forum Contributor
Posts: 439
Joined: Thu Aug 07, 2008 11:43 pm
Location: Hyderabad India

Re: Spacing Problem in table when using Paging...!

Post by susrisha »

I have seen the site and tried to view the images separately from the source. Its a path problem. There are no files in the given path. Check your file paths for the same.
asad_black
Forum Newbie
Posts: 20
Joined: Wed Feb 11, 2009 1:59 am

Re: Spacing Problem in table when using Paging...!

Post by asad_black »

my problem has been solved ...!
Post Reply