Re: [PHP] Pagination Part 2

[Jonathan Pitcher]

You are mixing and matching your If statements.

if ()

else

AND

if () {

} else {

}

Be consistent.  It looks like if you close the { tags your code should 
work ok.}

Hope this helps,

Jonathan Pitcher

On Wednesday, March 12, 2003, at 01:11  PM, conbud wrote:

Hi, Ive been trying to get this to work but I keep getting this error

Parse error: parse error, unexpected $ in /home/conbud/nrlug/test3.php 
on line 72

line 72 is just the ending php bracket, heres what I got:

<?php

    @mysql_connect(localhost, root, boing_boing) or die("ERROR--CAN'T 
CONNECT TO SERVER");
    @mysql_select_db("nrlug") or die("ERROR--CAN'T CONNECT TO DB");

    $limit        = 2;
    $query_count    = "SELECT lnkname FROM links";
    $result_count    = mysql_query($query_count);
    $totalrows    = mysql_num_rows($result_count);
    if(empty($page))
        $page = 1;
    $limitvalue = $page * $limit - ($limit);
    $query     = "SELECT * FROM links 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['lnkname']);
    echo("<td>\n\<td>");
    echo($row['id']);
    echo("<td>\n</tr>");
    }
    echo("</table>");

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

    for($i = '1'; $i <= $numofpages; $i++){
        if($i == $page)
            echo($i."&nbsp;");
        else
            echo("<a href=\"$PHP_SELF&page=$i\">$i</a>&nbsp;");
    if(($totalrows % $limit) != '0'){
        if($i == $page)
            echo($i."&nbsp;");
        else
            echo("<a href=\"$PHP_SELF&page=$i\">$i</a>&nbsp;");
    if(($totalrows - ($limit * $page)) > '0'){
        $pagenext = $page++;
        echo("<a href=\"$PHP_SELF&page=$pageprev\">NEXT</a>");
    }else
        echo("&nbsp; NEXT ".$limit);
    mysql_free_result($result);

?>

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php



--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php