Jump to content


Photo

Pagination not working


  • Please log in to reply
1 reply to this topic

#1 Arez

Arez
  • Members
  • PipPip
  • Member
  • 17 posts

Posted 03 June 2006 - 06:24 PM

Here is my current code

// this function views logs

function viewLogs() {

global $bordercolor1, $tablebg1;
echo "
<table align='center' border='1' bordercolor='$bordercolor1' cellspacing='0' cellpadding='0' width='550'>
<tr><td class='main' background='$tablebg1'><center><b>View Logs</b></center></td></tr>
<tr>
<td class='small'><br>
<blockquote>
";

$query = "SELECT * FROM log ORDER BY id DESC";
$result = mysql_query($query)
     or die("error");
while($row = mysql_fetch_array($result))
{
extract($row);
echo "
<b>Date:</b> $date1<br>
<b>Action:</b> $action<br>
<b>Reason:</b> $reason<br>
<hr size='1' width='500' color='$bordercolor1'>
<br>
";
}

$limit          = 25;              
    $query_count    = "SELECT count(*) FROM table";   
    $result_count   = mysql_query($query_count);   
    $totalrows      = mysql_num_rows($result_count);

    if(empty($page)){
        $page = 1;
    }
       

    $limitvalue = $page * $limit - ($limit);
    $query  = "SELECT * FROM table LIMIT $limitvalue, $limit";       
    $result = mysql_query($query) or die("Error: " . mysql_error());

    if(mysql_num_rows($result) == 0){
        echo("Nothing to Display!");
    }

    $bgcolor = "#E0E0E0"; // light gray

    echo("<table>");
   
    while($row = mysql_fetch_array($result)){
        if ($bgcolor == "#E0E0E0"){
            $bgcolor = "#FFFFFF";
        }else{
            $bgcolor = "#E0E0E0";
        }

    echo("<tr bgcolor=".$bgcolor.">n<td>");
    echo($row["users"]);
    echo("</td>n<td>");
    echo($row["usersID"]);
    echo("</td>n</tr>");
    }

    echo("</table>");

    if($page != 1){
        $pageprev = $page--;
       
        echo("<a href=\"$PHP_SELF&page=$pageprev\">PREV".$limit."</a> ");
    }else{
        echo("PREV".$limit." ");
    }

    $numofpages = $totalrows / $limit;
   
    for($i = 1; $i <= $numofpages; $i++){
        if($i == $page){
            echo($i." ");
        }else{
            echo("<a href=\"$PHP_SELF?page=$i\">$i</a> ");
        }
    }


    if(($totalrows % $limit) != 0){
        if($i == $page){
            echo($i." ");
        }else{
            echo("<a href=\"$PHP_SELF?page=$i\">$i</a> ");
        }
    }

    if(($totalrows - ($limit * $page)) > 0){
        $pagenext = $page++;
        
        echo("<a href=\"$PHP_SELF?page=$pagenext\">NEXT".$limit."</a>");
    }else{
        echo("NEXT".$limit);
    }
   
    mysql_free_result($result);

echo "</blockquote>
</td></tr>
</table>
";

} // end viewLogs function

And it gives me -
Error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'table LIMIT 0, 25' at line 1

it says that near the bottom of the logs. What'd I do wrong?


#2 sasa

sasa
  • Staff Alumni
  • Advanced Member
  • 2,804 posts
  • LocationHrvatska

Posted 04 June 2006 - 10:30 AM

change
table
to
`table`
So there's no confusion ... change that in the query.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users