Page 1 of 1

Paging problem!!!

Posted: Wed Sep 01, 2004 4:22 am
by deniscyriac
hi guys,

I'm facing some problem in paging data using php. It's working for the first page but, when I refresh the page or click on next it gives error. I'm adding the code below. help me please.

Code: Select all

<?
$hostname = "localhost"; 
$username = "********"; 
$password = "********";
$dbName = "reviewer";
 MYSQL_CONNECT($hostname, $username, $password) OR DIE("Unable to connect"); 
 @MYSQL_SELECT_DB("$dbName") OR DIE("Unable to select database"); 

if(!isset($start)) $start = 0;
$myreport = $_POST["report"];
$reports = $myreport;
$q= stripslashes($reports);
$query = $q. " LIMIT $start, 5";
$report1 = $q;
$query1 = $report1;
$result1 = mysql_query($query1);
$numrows = mysql_num_rows($result1); 

 $result = mysql_query($query); 
 $total_rows = mysql_num_rows($result); 
 $row = mysql_fetch_row($result);
 $total_cols = count($row); 
 $timetotalp= $timetotal;

 if (!$total_rows) { 
   print "<HTML><title>Reports</title><table width='800' border='0' cellspacing='3' cellpadding='3' align='center'>";
print "<tr bgcolor="#CCCCCC" height='200' align='center'><td><FONT size='2' face='Verdana, Arial, Helvetica, sans-serif'><b>No report found! Please search again.... </b></FONT></td></tr></table></BODY></HTML>"; 
   return;  
 } 
 print "<HTML><title>Reports</title><BODY text="#000000" link="#FFFFFF" vlink="#FFFFFF" alink="#FFFFFF" topmargin='0' marginheight='0'>";
 print "<table width='800' border='0' cellspacing='0' cellpadding='3' align='center'> "; 
 
 print "<tr bgcolor="#CCCCCC">"; 
$count = mysql_num_fields($result);
 for ($i = 0; $i < $count; $i++) {
print "<td><FONT size='2' face='Verdana, Arial, Helvetica, sans-serif'><b>";
$header = mysql_field_name($result, $i)."\t";
print $header;
print "</b></FONT></td>"; 
}
print "</tr>"; 
print "<tr>"; 

   $i=0; 
   while($i < $total_cols){ 
   print "<td><FONT size='1' face='Verdana, Arial, Helvetica, sans-serif'>"; 
   print $row[$i]; 
   print "</FONT></td>"; 
   $i++; 
 } 
 
 print "</tr>"; 

$j = 1;
 while($row = mysql_fetch_row ($result)) { 
 $j++;

   $i = 0; 
  if ($j%2 == 0) {
  print "<tr bgcolor=#F4F4F4>";
  }else{
   print "<tr bgcolor=#FFFFFF>";
}
   while($i < $total_cols){ 

     print "<td ><FONT size='1' face='Verdana, Arial, Helvetica, sans-serif'>"; 
     print $row[$i]; 
     print "</FONT></td>"; 
     $i++; 
  
   } 

 print "</tr>"; 
 } 

print "<tr bgcolor=#CCCCCC><td colspan=$total_cols align=center>";
print "<table width='100%' border='0' cellspacing='0' cellpadding='2' align='center'> "; 
print "<tr width='50%'><td align='left' width='25%'><FONT size='2' color='#FFFFFF' face='Verdana, Arial, Helvetica, sans-serif'>";
if($start > 0)
echo "<< <a href="" . $PHP_SELF . "?start=" . ($start - 5) ."&report=".$query1."">Previous</a>";
print "</FONT></td><td align='center' width='50%' height='20'><FONT size='2' color='#FFFFFF' face='Verdana, Arial, Helvetica, sans-serif'>";
print "<a href="javascript:void(window.print())"><img src="images\printicon.gif" border='0' alt='print'></a>";
print "</FONT></td><td align='right' width='25%' height='20'><FONT size='2' color='#FFFFFF' face='Verdana, Arial, Helvetica, sans-serif'>"; 
if($numrows > ($start + 5)) 

echo "<a href="" . $PHP_SELF . "?start=" . ($start + 5) ."&report=".$query1."">Next</a> >>"; 
print "</FONT></td></tr>";
print "</TABLE>";
print "</td></tr>";
print "</TABLE></BODY></HTML>"; 

?> 


?>

I'm passing the query from flash on a button click.

Code: Select all

report = "SELECT DATE_FORMAT(dateText, '%d-%m-%Y' ) AS  'Date' , indStatus AS 'Status', slideNo AS 'Slide', frameNo AS 'Frame', usName AS 'Reviewer', usComments AS 'Reviewer_Comments', indRectified AS 'Rectifiedby', indComments AS 'Developer_Comments' FROM reviews WHERE project='"+project+"' AND relatedTeam = '"+rTeam+"' ORDER BY dateText DESC";

getURL("http://192.168.1.12/reviewer/report.php?&amp;start=0&amp;report=SELECT%20DATE_FORMAT(dateText,'%d-%m-%Y')%20AS%20'Date',%20indStatus%20AS%20'Status',%20slideNo%20AS%20'Slide',%20frameNo%20AS%20'Frame',%20usName%20AS%20'Reviewer',%20usComments%20AS%20'Reviewer_Comments',%20indRectified%20AS%20'Rectifiedby',%20indComments%20AS%20'Developer_Comments'%20FROM%20reviews%20WHERE%20project=''"+project+"''%20AND%20relatedTeam=''"+rTeam+"''%20ORDER%20BY%20dateText%20DESC", "_blank", "POST");

Could you please help me to solve this issue.

thanks,
Denis


feyd | stripped user/pass