0

Hi,
I have a strange situation to tackle.I have a paging for the website I am developing.
there are few records in the table which i want to skip from to display in my list in the web page.
But paging works on the total num rows as using mysql_num_rows(resultset)

2
Contributors
4
Replies
5
Views
8 Years
Discussion Span
Last Post by multicoder
0
if(isset($_REQUEST['page']) || $_REQUEST['page']==" ")
		 $pageindex = $_REQUEST['page'];
	else
		 $pageindex = 1;

	$Tourcnt=mysql_num_rows($sqlThingsToDo);

	$TotalPage = ceil($Tourcnt / $pagesize);
	
	if($pageindex == 1)
		$StartPage = 0;
	else
		$StartPage = ($pageindex -1) * $pagesize;
	if($pagesize*$pageindex < $Tourcnt)
		$EndPage = $pagesize * $pageindex;
	else
		$EndPage = $Tourcnt;

	$ResultPagiing = $dbConnection->query($qThingsToDo." LIMIT ".$StartPage.", ".$pagesize);
0

So here the problem is, it still shows the 9 records on a page if particular record is faulty and we are not showing it,but in the paging we get to see paging from records '11 to 20'
or in other words we are not able to exclude the record from fetching completely.
Is there anything we can manipulate mysql_fetch_array for any particular record depending upon its content or we can rearrange the paging considering the excluded record..?

0

sory, i am leaning towards .. state, working on mulitple technologies!
Can anybody move it to PHP forum?

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.