Help Please: Pagination (Record Limiting)

[The_MA]

Hi there, here is my problem and thanks for anyone who helps! x

The code below lists records from the response_log. It is meant to display the first 30 records only and when "View 100 records" is pressed it is meant to show 100 records. I've put in an else function so that when the user goes to the view of 100 records it should show a new link saying "View 30 records". This doesn't work and I can't be sure the limit works either as I don't actually have that many records yet.

<? php  

$end=isset($HTTP_GET_VARS['e'])?$HTTP_GET_VARS['e']:30;  

$PHP_SELF=isset($HTTP_SERVER_VARS['PHP_SELF'])?$HTTP_SERVER_VARS['PHP_SELF']:'';   

$sql = "select logID, commandID, userID, response, response_date, response_time from response_log   

order by logID DESC limit 0,$end";  

$rs = @mysql_query( $sql,$conn);  

$rows = mysql_num_rows($rs);  

echo( "<table><tr bgcolor=\"#CCCCCC\"><td colspan=\"6\">  

<center>View of Log</td></font>" );  

if ($end=30) {  

echo( "<td colspan=\"2\"><center><font size=\"1\" face=\"Verdana\">  

<a href='$PHP_SELF?e=100'>View 100 Records</a></font></td></tr>" );   

}  

else                                // The else doesn't happen  

{  

if ($end=100) {  

echo( "<td colspan=\"2\"><center><font size=\"1\" face=\"Verdana\">  

<a href='$PHP_SELF?e=30'>View 30 Records</a></font></td></tr>" );   

}}                                                  // Field Headings  

   echo( "<tr><td><font size=\"1\" face=\"Verdana\"><strong>Log #</td>" );  

   echo( "<td><font size=\"1\" face=\"Verdana\"><strong>Command Name</td>" );  

   echo( "<td><font size=\"1\" face=\"Verdana\"><strong>Username</td>" );  

   echo( "<td><font size=\"1\" face=\"Verdana\"><strong>Response</td>" );  

   echo( "<td><font size=\"1\" face=\"Verdana\"><strong>Date</td>" );  

   echo( "<td><font size=\"1\" face=\"Verdana\"><strong>Time</td></tr>" );  

if(mysql_num_rows($rs))  

{  

while( $row = mysql_fetch_array( $rs ) )  

                        // Records listed below  

{  

   echo( "<tr><td><font size=\"2\" face=\"Verdana\">" . $row["logID"] . "</td>" );  

   echo( "<td><font size=\"2\" face=\"Verdana\">" . $row["commandID"] . "</td>" );  

   echo( "<td><font size=\"2\" face=\"Verdana\">" . $row["userID"] . "</td>" );  

   echo( "<td><font size=\"2\" face=\"Verdana\">" . $row["response"] . "</td>" );  

   echo( "<td><font size=\"2\" face=\"Verdana\">" . $row["response_date"] . "</td>" );  

   echo( "<td><font size=\"2\" face=\"Verdana\">" . $row["response_time"] . "</td></tr>" );  

}  

?> 

[leatherback]

Hi,

It does not work, as you have your equal signs messed up. The single '=' assigns a value to a variable, and returns 'true' when succesfull. YOu need the double ==, which tests for being equal (Read the manual about operators or see my basics tutorials on www.bio-vision.nl/coding.

ABout debugging, and testing the code: Who is to stop you from testing between showing 1 or 2 records? Be creative!

if ($end==30) {  

echo( "<td colspan=\"2\"><center><font size=\"1\" face=\"Verdana\">  

<a href='$PHP_SELF?e=100'>View 100 Records</a></font></td></tr>" );   

}  

else                                // Do not need to test, this is the default
{  

echo( "<td colspan=\"2\"><center><font size=\"1\" face=\"Verdana\">  

<a href='$PHP_SELF?e=30'>View 30 Records</a></font></td></tr>" );   

}

Last but not least: Use stulesheets (CSS) for formatting your output, and remove the font, center etc tags.