[SOLVED] Spacing Problem in table when using Paging...

[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:

Quote:

<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>

[Adam]

I can't see any difference?

 

Adam