[Resolved] Pagination help

[rprincejr]

I cant figure out why the pagination links dont work. Any ideas?

    $limit          = 25;
    $query_count    = "SELECT count(*) FROM " . $user_prefix . "_newsletter WHERE email LIKE '$letter%' ORDER BY email ASC";
    $totalrows      = @mysql_num_rows($query_count);

    $letter = $_REQUEST['letter'];
    $page = intval($_REQUEST['page']);
    if($page==0){
    $page = 1;
    }

$limitvalue = $page * $limit - ($limit);

            if($_REQUEST['letter'] == 'A'){
                        $result = mysql_query("SELECT * FROM " . $user_prefix . "_newsletter WHERE email LIKE 'A%' ORDER BY email ASC LIMIT $limitvalue, $limit");
            }
            elseif($_REQUEST['letter'] == 'B'){
                        $result = mysql_query("SELECT * FROM " . $user_prefix . "_newsletter WHERE email LIKE 'B%' ORDER BY email ASC LIMIT $limitvalue, $limit");
            }

    OpenTable();
    echo "<center><b>Off-Site Email Administration</b><br><br>"
        ."<a href=\"admin.php?op=newsletter\">[Back to Newsletter Main]</a><br></center>"
        ."<hr><br><center><b><u>Off-Site Email Index</b></u><br><br>";
    echo "<form method=\"POST\" action=\"$_SERVER[PHP_SELF]\">"
        ."<b>Sort by Letter</b>&nbsp;"
        ."<select name=\"letter\"><option>Choose One</option>"
        ."<option value=\"A\">A</option>"
        ."<option value=\"B\">B</option>"
        ."</select>&nbsp;"
        ."<input type=\"hidden\" name=\"op\" value=\"sort_email\">"
        ."<input type=\"hidden\" name=\"page\" value=\"1\">"
        ."<input type=\"submit\" name=\"submit\" submit value=\"GO!\"></form>";

    echo "</center><br>";
    echo "<table width=\"90%\" cellspacing=\"1\" cellpadding=\"6\" border=\"0\" align=\"center\">"
        ."<tr bgcolor=\"#e6e6e6\">"
        ."<td width=\"10%\" align=\"center\"><b>No.</b></td>"
        ."<td width=\"40%\" align=\"left\"><b>Email Address</b></td>"
        ."<td width=\"20%\" align=\"center\"><b>Email ID</b></td>"
        ."<td width=\"30%\" align=\"center\"><b>Functions</b></td>"
        ."</tr></table>";

if(@mysql_num_rows($result) == 0){
    echo("<center><b>No Emails starting with that letter found.</b></center>");
}

$bgcolor = "#e6e6e6"; // light gray - second displayed color

echo("<table width=\"90%\" cellspacing=\"1\" cellpadding=\"6\" border=\"0\" align=\"center\">");


            $emailno = 1;
while($row = @mysql_fetch_array($result)){
                    if($bgcolor == "#e6e6e6"){
                            $bgcolor = "#FFFFFF";
                    }else{
                            $bgcolor = "#e6e6e6";
                    }
        echo "<table width=\"90%\" cellspacing=\"1\" cellpadding=\"6\" border=\"0\" align=\"center\">";
        echo "<tr bgcolor=".$bgcolor."><td width=\"10%\" align=\"center\">$emailno.</td>";
        echo "<td width=\"40%\" align=\"left\">$row[email]</td>";
        echo "<td width=\"20%\" align=\"center\">$row[nlid]</td>";
        echo "<td width=\"30%\" align=\"center\" valign=\"middle\">";
        echo "<input type=\"button\" value=\"Edit\" title=\"Edit\" onClick=\"window.location='?op=emailedit&amp;nlid=$nlid#Edit'\">&nbsp;&nbsp;";
        echo "<input type=\"button\" value=\"Delete\" title=\"Delete\" onClick=\"window.location='?op=emaildelete&amp;nlid=$nlid#Delete'\">";
        echo "</td></tr>";
            $emailno++;
}

echo("</table>");
echo("<table width=\"90%\" border=\"0\"><tr align=\"center\"><td>");
/* Pagination Links */

if($page != 1){
    $pageprev = $page - 1;

    echo("<a href=\"?page=$pageprev&letter=$letter\">PREV</a>&nbsp;&nbsp;&nbsp;");
}else{
    echo("PREV&nbsp;&nbsp;&nbsp;");
}

$numofpages = ceil($totalrows / $limit);

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

if(($totalrows - ($limit * $page)) > 0){
    $pagenext = $page + 1;

    echo("&nbsp;&nbsp;&nbsp;<a href=\"?page=$pagenext&letter=$letter\">NEXT</a>&nbsp;");
}else{
    echo("&nbsp;&nbsp;&nbsp;NEXT&nbsp;&nbsp;&nbsp;");
}


echo("</td></tr></table>");
    CloseTable();
    include("footer.php");
    mysql_free_result($result);
}

[leatherback]

Could you be a bit more precise on what is not working?

J.

[rprincejr]

the links for the pagination. They are only showing up as text which would be the else conditional in each of the link statements. Sorry for not being more specific. Also the middle links such as 1 2 3, etc... dont show up at all. The prev and next are just text as stated above.

[leatherback]

Eehm..
Place some error messages here and there. Ecxho out the queries you ar erunning. I think something is wrong in the queries then.

So:

• Remove the @ after the = symbols. You are still debugging: Might as well show all the errors

• Place or die('query NUMBER has a problem:'.mysql_error()) after each query you run (After the mysql_query() )

Then post the eroors, or read them, and see whether you can fic them.

-- I am siging off, 1 AM here --

J.

[rprincejr]

I found the problem. It was in the count function. I instead dropped the count function and just called out the fields in the query and it worked. I am posting the original query which didnt work and the new query which does work. Thanks for the tips on troubleshooting Leather. I am renaming this post to [resolved].

ORIGINAL QUERY:

$limit          = 25;
    $query_count    = "SELECT count(*) FROM " . $user_prefix . "_newsletter WHERE email LIKE '$letter%' ORDER BY email ASC";
    $totalrows      = @mysql_num_rows($query_count);

NEW WORKING QUERY:

        $limit          = 25;
        $query          = "SELECT nlid, email FROM " . $user_prefix . "_newsletter WHERE email LIKE '$letter%' ORDER BY email ASC";
        $query_count    = mysql_query($query);
        $totalrows      = mysql_num_rows($query_count);