rendered paste body$self = $_SERVER['PHP_SELF'];$offsetand10 = $offset + 10; $offsetminus10 = $offset - 10; if($letterq){if ($offset == "0"){ $nextquery = mysql_query("SELECT * FROM rpn_new_albums WHERE artist LIKE '$letterq%' ORDER BY datetime ASC");} else{ $nextquery = mysql_query("SELECT * FROM rpn_new_albums WHERE artist LIKE '$letterq%' ORDER BY datetime ASC LIMIT " . $offset + 10 . ",10");}} if(empty($letterq)){if ($offset == "0"){ $nextquery = mysql_query("SELECT aid FROM rpn_new_albums ORDER BY datetime ASC LIMIT 10,10");} else{ $nextquery = mysql_query("SELECT aid FROM rpn_new_albums ORDER BY datetime ASC LIMIT " . $offset + 10 . ",10");}} $nextpagenum = @mysql_num_rows($nextquery); print ("<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"98%\"><tr>\n"); if ($offset <= 0){ } else if ($offset < 10){ print("<td align=\"left\" class='caption2'><a href=\"$self?offset=0\"><< Previous ".$offset." Entries</a></td>\n"); } else if ($offset >= 10){ print("<td align=\"left\" class='caption2'><a href=\"$self?offset=".$offsetminus10 ."\"><< Previous 10 Entries</a></td>\n"); } if ($nextpagenum != 0){ print("<td align=\"right\" class='caption2'><a href=\"$self?offset=".$offsetand10."\">Next ".$nextpagenum." Entries >></a></td>\n"); } print("</tr></table>\n");