Pagination Part 2

From: Date: Wed, 12 Mar 2003 19:11:38 +0000
Subject: Pagination Part 2
Groups: php.general 
Request: Send a blank email to php-general+get-139367@lists.php.net to get a copy of this message
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);
?>

« previous php.general (#139367) next »