[Resolved] pagination problem!

sirTemplar

hi again. i just got a pagination code here by batman. but i have these problems.

this is the complete code:

$limit = 8;  

$query_count = "SELECT * FROM thisday WHERE 
				(EVENTYEAR LIKE '%$EVENTYEAR%' 
                AND EVENTDATE LIKE '%$EVENTDATE%') 
				ORDER BY EVENTDATE DESC ";  

$result_count = mysql_query($query_count); 
$totalrows = mysql_num_rows($result_count);  

if(empty($page))  

$page = 1;  

$limitvalue = $page * $limit - ($limit);  

$query = "SELECT * FROM thisday WHERE 
			(EVENTYEAR LIKE '%$EVENTYEAR%' 
			AND EVENTDATE LIKE '%$EVENTDATE%') 
			ORDER BY EVENTDATE DESC
			LIMIT $limitvalue, $limit ";  

$result = mysql_query($query) or die("Error: " . mysql_error());  

$count_result = mysql_num_rows($result); 

// Display links at the top to indicate current page and number of pages displayed 
$numofpages = ceil($totalrows / $limit); 
echo"<br><p><b>$totalrows</b> result(s) for: \"$search\"</p>"; 
$from=$limit*$page-$limit+1; 
$to=$from + $count_result-1; 

// start 123 next>> table 
echo "<table align=\"center\" width=\"90%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\"> 
            <tr><td width=\"50%\" bgcolor=\"$bg_colour\" align=\"left\">";if($numofpages>1){echo"Showing: $from - $to</td><td width=\"50%\" bgcolor=\"$bg_colour\" align=\"right\"><b>Go to page:</b> ";}  

// display previous link if page is not 1 
if($page != 1){  

$pageprev = $page - 1;  

echo("<a href=\"$PHP_SELF?page=$pageprev&search=$search\"><< PREV</a>&nbsp;");  

}  

// display page nos if not 1 
for($i = 1; $i <= $numofpages; $i++){  

if($numofpages>1){ 
if($i == $page)  

echo("&nbsp;".$i."&nbsp;");  

else 
echo("&nbsp;<a href=\"$PHP_SELF?page=$i&search=$search\">$i</a>&nbsp;");  

}} 

// display next page link if there is more than one 
if(($totalrows - ($limit * $page)) > 0){  

$pagenext = $page + 1;  

echo("<a href=\"$PHP_SELF?page=$pagenext&search=$search\">NEXT >></a>");  

} 
// end 123 next>> table 
echo"</td></tr></table><br>";


if (($row["DAY"]) == "00")

{
echo "<table bgcolor=#FFFEEF border=0 cellpadding=2 cellspacing=0 style=border-collapse: collapse bordercolor=#111111 width=100%> 
<tr><td align=left width=20% valign=top><b><font face=Verdana size=2 color=#800080><li>{$row['EVENTYEAR']}-{$row['MONTH']}</font></b></td> 
<td align=justify width=80% valign=top><font face=Verdana size=2 color=#000000>{$row['EVENTTEXT']}</td></table>";  

}

else

{
echo "<table bgcolor=#FFFEEF border=0 cellpadding=2 cellspacing=0 style=border-collapse: collapse bordercolor=#111111 width=100%> 
<tr><td align=left width=20% valign=top><b><font face=Verdana size=2 color=#800080><li>{$row['EVENTDATE']}</font></b></td> 
<td align=justify width=80% valign=top><font face=Verdana size=2 color=#000000>{$row['EVENTTEXT']}</td></table>"; 
}

  echo ("<p>");  

  echo ("<p>");  

?>

when i do a search it correctly displays, the number or records found but it shows something like

24 result(s) for: ""

and the records are not shown! which is the part of the code.

if (($row["DAY"]) == "00")

{
echo "<table bgcolor=#FFFEEF border=0 cellpadding=2 cellspacing=0 style=border-collapse: collapse bordercolor=#111111 width=100%> 
<tr><td align=left width=20% valign=top><b><font face=Verdana size=2 color=#800080><li>{$row['EVENTYEAR']}-{$row['MONTH']}</font></b></td> 
<td align=justify width=80% valign=top><font face=Verdana size=2 color=#000000>{$row['EVENTTEXT']}</td></table>";  

}

else

{
echo "<table bgcolor=#FFFEEF border=0 cellpadding=2 cellspacing=0 style=border-collapse: collapse bordercolor=#111111 width=100%> 
<tr><td align=left width=20% valign=top><b><font face=Verdana size=2 color=#800080><li>{$row['EVENTDATE']}</font></b></td> 
<td align=justify width=80% valign=top><font face=Verdana size=2 color=#000000>{$row['EVENTTEXT']}</td></table>"; 
}

and also, when i try to press the next button, if goes to count all the data on the database but never showing the data! what could be wrong?

thanks.

kevinsequeira

the code has a variable called $search, where do u get the value of $search from ??

reg
kevin

sirTemplar

i have a search form that does the search! help!

kevinsequeira

echo" $totalrows result(s) for: \"$search\"";

..
..
..
echo("<a href=\"$PHP_SELF?page=$pagenext&search=$search\">NEXT >></a>");

this is part of the code, where are u getting $search value from ???

reg
kevin

kevinsequeira


if(isSet($search)){
	$d_array = explode("|",$search);
	$EVENTYEAR = $d_array[0];
	$EVENTDATE = $d_array[1];	
}	
$limit = 8;  

$query_count = "SELECT * FROM thisday WHERE 
                (EVENTYEAR LIKE '%$EVENTYEAR%'
                AND EVENTDATE LIKE '%$EVENTDATE%')
                ORDER BY EVENTDATE DESC ";  

$search = $EVENTYEAR."|".$EVENTDATE;
$search_display = $EVENTYEAR." AND ".$EVENTDATE;
$result_count = mysql_query($query_count); 
$totalrows = mysql_num_rows($result_count);  

.
.
.
.
.
.
echo"<br><p><b>$totalrows</b> result(s) for: \"$search_display\"</p>";

reg
kevin

sirTemplar

the pagination works fine now🙂 though it is showing

22 result(s) for: "% AND -07-"

my big problem now is the actual data is not being printed! which is this part of the code:

if (($row["DAY"]) == "00") 

{ 
echo "<table bgcolor=#FFFEEF border=0 cellpadding=2 cellspacing=0 style=border-collapse: collapse bordercolor=#111111 width=100%> 
<tr><td align=left width=20% valign=top><b><font face=Verdana size=2 color=#800080><li>{$row['EVENTYEAR']}-{$row['MONTH']}</font></b></td> 
<td align=justify width=80% valign=top><font face=Verdana size=2 color=#000000>{$row['EVENTTEXT']}</td></table>";   

} 

else 

{ 
echo "<table bgcolor=#FFFEEF border=0 cellpadding=2 cellspacing=0 style=border-collapse: collapse bordercolor=#111111 width=100%> 
<tr><td align=left width=20% valign=top><b><font face=Verdana size=2 color=#800080><li>{$row['EVENTDATE']}</font></b></td> 
<td align=justify width=80% valign=top><font face=Verdana size=2 color=#000000>{$row['EVENTTEXT']}</td></table>";  

}

it only shows how many e.g. 22 result(s) for: "% AND -07-"

kevinsequeira

$result = mysql_query($query) or die("Error: " . mysql_error());

$count_result = mysql_num_rows($result);

at a glance i couldnt find this

$row = mysql_fetch_array($result);

after the above code, so if its not there add the line so that it looks like this

$result = mysql_query($query) or die("Error: " . mysql_error());

$count_result = mysql_num_rows($result);

$row = mysql_fetch_array($result);

reg
kevin

sirTemplar

thanks for the patience! 🙂 i think i have one more problem! the output prints e.g. Showing: 25 - 25 or Showing: 9 - 16
but it actually displays per page not 8 as the limit should be!

one more thing: how do i output also the number of data on the database on the result like 25 out of 50!

kevinsequeira

i think i have one more problem! the output prints e.g. Showing: 25 - 25 or Showing: 9 - 16
but it actually displays per page not 8 as the limit should be!

dont understand what u mean

u have set the limit to be 8 so 9-16 are 8 records and 25-25 is the last remaining so it obvioulsly cant show 8 records the last time

reg
kevin

sirTemplar

sorry if i was not clear. what i mean is this, it tells me showing records 1 to 8 but it actually is showing only 1 record! so for example if the search should output 16 records, the first page says 1 of 8 then the second page 9-16 but these two pages have only one record shown! let me show you what i mean:

first page

25 result(s) for:

Showing: 1 - 8 Go to page: 1 2 3 4 NEXT >>

2002-06-16 : text here

second page

25 result(s) for:

Showing: 9 - 16 Go to page: << PREV 1 2 3 4 NEXT >>

1974-06-07 - text here

instead of showing for example:

25 result(s) for:

Showing: 1 - 8 Go to page: 1 2 3 4 NEXT >>

2002-06-16 : text here
2002-06-16 : text here
2002-06-16 : text here
2002-06-16 : text here
2002-06-16 : text here
2002-06-16 : text here
2002-06-16 : text here
2002-06-16 : text here

kevinsequeira

make this change

while($row=mysql_fetch_array($result)){
  if (($row["DAY"]) == "00"){
  echo "<table bgcolor=#FFFEEF border=0 cellpadding=2 cellspacing=0 style=border-collapse: collapse bordercolor=#111111 width=100%>
  <tr><td align=left width=20% valign=top><b><font face=Verdana size=2 color=#800080><li>{$row['EVENTYEAR']}-{$row['MONTH']}</font></b></td>
  <td align=justify width=80% valign=top><font face=Verdana size=2 color=#000000>{$row['EVENTTEXT']}</td></table>";  

  }else{
  echo "<table bgcolor=#FFFEEF border=0 cellpadding=2 cellspacing=0 style=border-collapse: collapse bordercolor=#111111 width=100%>
  <tr><td align=left width=20% valign=top><b><font face=Verdana size=2 color=#800080><li>{$row['EVENTDATE']}</font></b></td>
  <td align=justify width=80% valign=top><font face=Verdana size=2 color=#000000>{$row['EVENTTEXT']}</td></table>"; 
  }
  echo ("<p>");  

  echo ("<p>");   

}

remove the earier $row = mysql_fetch_array($result); that i asked u to put in my earlier reply

reg
kevin

sirTemplar

😃 🙂 i am a happy man! thank you very much! all is working perfectly now! thanks again for the patience.

lastly, how do i print the total number of records on the database? something like 25 out of 50 record(s) found. i have already the one to print the 25 which is $totalrows.

kevinsequeira

print out the variables $from and $to. see if that works

reg
kevin

sirTemplar

not working!

kevinsequeira

// Display links at the top to indicate current page and number of pages displayed
$numofpages = ceil($totalrows / $limit);
echo" $totalrows result(s) for: \"$search\"";
$from=$limit*$page-$limit+1;
$to=$from + $count_result-1;

// start 123 next>> table
echo "<table align=\"center\" width=\"90%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">
<tr><td width=\"50%\" bgcolor=\"$bg_colour\" align=\"left\">";if($numofpages>1){echo"Showing: $from - $to</td><td width=\"50%\" bgcolor=\"$bg_colour\" align=\"right\">Go to page: ";}

this is the bit that does it in your code, try printing the different values to see what u get.

reg
kevin

kevinsequeira

still need help?? post your edited / latest working code. is there a link to this page or is it on ure local machine ?

reg
kevin

sirTemplar

thanks for all the help! i have worked out everything already. what i am trying to do now is how to add buttons to be able to order the output in different format. 🙂