<div>
here is a sample of my typical paging 
&nbsp;&lt;?php 
include 'config.php'; 
include 'opendb.php'; 
$pagecolor1 = '#FFFFCC'; 
 
// how many rows to show per page 
$rowsPerPage = 4; 
 
// by default we show first page 
$pageNum = 1; 
 
// if $_GET['page'] defined, use it as page number 
if(isset($_GET['page'])) 
{ 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$pageNum = $_GET['page']; 
} 
 
// counting the offset 
$offset = ($pageNum - 1) * $rowsPerPage; 
 
$query &nbsp;= &quot;SELECT id, title, blog_title, blog, rating, date FROM tbl_blogrev1 order by id desc LIMIT $offset, $rowsPerPage&quot;; 
$result = mysql_query($query) or die('Error, query failed'); 
 
// print the random numbers 
while(list( $id, $title, $blog_title, $blog, $rating, $date) = mysql_fetch_array($result)) 
{ 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;echo &quot; &nbsp; $title &nbsp; &nbsp; &nbsp;
<hr />
 $blog_title &nbsp; 
&nbsp; $blog 
&nbsp; $rating 

<hr />
&quot;; 
} 
 
{ 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;echo &quot;&nbsp;&quot;; 
} 
 
// how many rows we have in database 
$query &nbsp; = &quot;SELECT COUNT(id) AS numrows FROM tbl_blogrev1&quot;; 
$result &nbsp;= mysql_query($query) or die('Error, query failed'); 
$row &nbsp; &nbsp; = mysql_fetch_array($result, MYSQL_ASSOC); 
$numrows = $row['numrows']; 
 
// how many pages we have when using paging? 
$maxPage = ceil($numrows/$rowsPerPage); 
 
$self = $_SERVER['PHP_SELF']; 
 
// creating 'previous' and 'next' link 
// plus 'first page' and 'last page' link 
 
// print 'previous' link only if we're not 
// on page one 
if ($pageNum &gt;&nbsp;1) 
{ 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$page = $pageNum - 1; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$prev = &quot;&nbsp;<a href="http://\&quot;$self?page=$page\&quot;" rel="ugc nofollow">[Prev]</a> &quot;; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$first = &quot;&nbsp;<a href="http://\&quot;$self?page=1\&quot;" rel="ugc nofollow">[First Page]</a> &quot;; 
} 
else 
{ 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$prev &nbsp;= ' [Prev] '; &nbsp; &nbsp; &nbsp; // we're on page one, don't enable 'previous' link 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$first = ' [First Page] '; // nor 'first page' link 
} 
 
// print 'next' link only if we're not 
// on the last page 
if ($pageNum &lt;&nbsp;$maxPage) 
{ 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$page = $pageNum + 1; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$next = &quot;&nbsp;<a href="http://\&quot;$self?page=$page\&quot;" rel="ugc nofollow">[Next]</a> &quot;; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$last = &quot;&nbsp;<a href="http://\&quot;$self?page=$maxPage\&quot;" rel="ugc nofollow">[Last Page]</a> &quot;; 
} 
else 
{ 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$next = ' [Next] '; &nbsp; &nbsp; &nbsp;// we're on the last page, don't enable 'next' link 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$last = ' [Last Page] '; // nor 'last page' link 
} 
 
// print the page navigation link 
echo $first . $prev . &quot;&nbsp;Showing page $pageNum of $maxPage pages &quot;&nbsp;. $next . $last; 
 
include 'closedb.php'; 
?&gt;
</div>

<div>
place 
if (isset($_GET['letter'])) { 
$letter = $_GET['letter']; 
} else {$letter= false; &nbsp;} 
at the top 
 
change 
$query &nbsp;= &quot;SELECT id, title, blog_title, blog, rating, date FROM tbl_blogrev1 order by id desc LIMIT $offset, $rowsPerPage&quot;; 
to 
if ($letter) { 
$query &nbsp;= &quot;SELECT id, title, blog_title, blog, rating, date FROM tbl_blogrev1 
WHERE LEFT(blog_title,1) = '$letter' 
ORDER BY id desc LIMIT $offset, $rowsPerPage&quot;; 
} else { 
$query &nbsp;= &quot;SELECT id, title, blog_title, blog, rating, date FROM tbl_blogrev1 order by id desc LIMIT $offset, $rowsPerPage&quot;; 
&nbsp;}
</div>

<div>
I guess I didn't explain myself too well. 
I want the paging to show at top/bottom a b c d e f g &nbsp; by title. so if i click on a I will get in alphabetical order the first 5 results of titles starting with an a and then inside of that catagory. page 12345 if there are more than 5 results in the count. Hope that makes more sense. Thanks
</div>

<div>
in other words, you want me to write the entire page for you rather than explain how to do it?
</div>

<div>
I'll figure it out, thanks anyway.
</div>

<div>
I've got a start on this but am missing some critical pieces to make the letters work. Please help me if your know this stuff. Thanks 
 
&lt;?php 
$alphabet = array('A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z'); 
foreach ($alphabet as $letter) { 
echo &quot;<a href="http://\&quot;?letter=&quot;" rel="ugc nofollow">&quot; . $letter . &quot;</a>&amp;nbsp;¦&amp;nbsp;&quot;; 
} 
?&gt; 
 
 
 
 
&lt;!--mysql--&gt; 
&lt;?php 
if(empty($_POST)) { 
$letter = $_GET['letter']; 
$letter .= &quot;%&quot;; 
$search = $letter; 
$sdesc = &quot;*&quot;; 
$classquery = &quot;&quot;; 
} else { 
$search = $_POST['search']; 
$search = &quot;%&quot; . $search . &quot;%&quot;; 
$sdesc = &quot;%&quot; . $search . &quot;%&quot;; 
$sclass = $_POST['category_eng']; 
$classquery = &quot;AND 'category_eng' = CONVERT( _utf8 '&quot; . $sclass . &quot;' USING latin1 )&quot;; 
} 
include 'config.php'; 
include 'opendb.php'; 
// If current page number, use it 
// if not, set one! 
 
 
if(!isset($_GET['page'])){ 
$page = 1; 
} else { 
$page = $_GET['page']; 
} 
 
// Define the number of results per page 
$max_results = 5; 
 
// Figure out the limit for the query based 
// on the current page number. 
$from = (($page * $max_results) - $max_results); 
 
// Perform mysql query on only the current page number's results 
$result = mysql_query(&quot;SELECT * FROM tbl_blogrev1 ORDER BY title DESC LIMIT $from, $max_results&quot;) 
or die(mysql_error()); 
 
//TO PRINT OUT THE DATA 
echo &quot;&quot;; 
echo &quot;&nbsp;ID title blog_title blog rating date&quot;; 
// keeps getting the next row until there are no more to get 
while($saba = mysql_fetch_array( $result )) { 
// Print out the contents of each row into a table 
echo &quot;&quot;; 
echo $saba['id']; 
echo &quot;&quot;; 
echo $saba['title']; 
echo &quot;&quot;; 
echo $saba['blog_title']; 
echo &quot;&quot;; 
echo $saba['blog']; 
echo &quot;&quot;; 
echo $saba['rating']; 
echo &quot;&quot;; 
echo $saba['date']; 
 
echo &quot;&quot;; 
} 
 
echo &quot;&quot;; 
//STOP PRINTING OUT THE DATA 
 
// Figure out the total number of results in DB: 
$total_results = mysql_result(mysql_query(&quot;SELECT COUNT(*) as Num FROM tbl_blogrev1 ORDER BY id DESC&quot;),0); 
 
// Figure out the total number of pages. Always round up using ceil() 
$total_pages = ceil($total_results / $max_results); 
 
// Build Page Number Hyperlinks 
echo &quot;Pages: &quot;; 
 
// Build Previous Link 
if($page &gt;&nbsp;1){ 
$prev = ($page - 1); 
echo &quot;<a href="http://\&quot;&quot;.$_SERVER['php_SELF'" rel="ugc nofollow">.&quot;?page=$prev\&quot;]&amp;laquo;</a> &quot;; 
} 
 
for($i = 1; $i &lt;= $total_pages; $i++){ 
if(($page) == $i){ 
echo &quot;$i &quot;; 
} else { 
echo &quot;<a href="http://\&quot;&quot;.$_SERVER['php_SELF'" rel="ugc nofollow">.&quot;?page=$i]$i</a> &quot;; 
} 
} 
 
// Build Next Link 
if($page &lt;&nbsp;$total_pages){ 
$next = ($page + 1); 
echo &quot;<a href="http://\&quot;&quot;.$_SERVER['php_SELF'" rel="ugc nofollow">.&quot;?page=$next\&quot;]&amp;raquo;</a>&quot;; 
} 
echo &quot; 
&quot;; 
 
mysql_close(); 
?&gt;
</div>

<div>
put &nbsp;this block: 
 
&lt;?php 
$alphabet = array('A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z'); 
foreach ($alphabet as $letter) { 
echo &quot;&quot;&nbsp;. $letter . &quot;&amp;nbsp;¦&amp;nbsp;&quot;; 
} 
?&gt; 
 
beneath the assignment of $letter 
 
and change it to: 
 
&lt;?php 
$alphabet = array('A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z'); 
foreach ($alphabet as $loop_letter) { 
&nbsp; if ($loop_letter == $letter) { echo ''; } 
&nbsp; echo &quot;<a href="http://pagename.php?letter=" rel="ugc">&quot; . $loop_letter . &quot;</a>&amp;nbsp;¦&amp;nbsp;&quot;; 
&nbsp; if ($loop_letter == $letter) { echo ''; } 
} 
?&gt; 
 
other than that, your code looks pretty good
</div>

<div>
So like this? This deactivates my letters and links? 
 
&lt;!--mysql--&gt; 
&lt;?php 
if(empty($_POST)) { 
$letter = $_GET['letter']; 
$letter .= &quot;%&quot;; 
$search = $letter; 
$alphabet = array('A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z'); 
foreach ($alphabet as $loop_letter) { 
&nbsp; if ($loop_letter == $letter) { echo ''; } 
&nbsp; echo &quot;&quot;&nbsp;. $loop_letter . &quot;&amp;nbsp;¦&amp;nbsp;&quot;; 
&nbsp; if ($loop_letter == $letter) { echo ''; } 
} 
$sdesc = &quot;*&quot;; 
$classquery = &quot;&quot;; 
} else { 
$search = $_POST['search']; 
$search = &quot;%&quot; . $search . &quot;%&quot;; 
$sdesc = &quot;%&quot; . $search . &quot;%&quot;; 
$sclass = $_POST['title']; 
$classquery = &quot;AND 'title' = CONVERT( _utf8 '&quot; . $sclass . &quot;' USING tbl_blogrev1 )&quot;; 
} 
 
 
include 'config.php'; 
include 'opendb.php'; 
// If current page number, use it 
// if not, set one! 
 
 
if(!isset($_GET['page'])){ 
$page = 1; 
} else { 
$page = $_GET['page']; 
} 
 
// Define the number of results per page 
$max_results = 5; 
 
// Figure out the limit for the query based 
// on the current page number. 
$from = (($page * $max_results) - $max_results); 
 
// Perform mysql query on only the current page number's results 
$result = mysql_query(&quot;SELECT * FROM tbl_blogrev1 ORDER BY title DESC LIMIT $from, $max_results&quot;) 
or die(mysql_error()); 
 
//TO PRINT OUT THE DATA 
echo &quot;&quot;; 
echo &quot;&nbsp;ID title blog_title blog rating date&quot;; 
// keeps getting the next row until there are no more to get 
while($saba = mysql_fetch_array( $result )) { 
// Print out the contents of each row into a table 
echo &quot;&quot;; 
echo $saba['id']; 
echo &quot;&quot;; 
echo $saba['title']; 
echo &quot;&quot;; 
echo $saba['blog_title']; 
echo &quot;&quot;; 
echo $saba['blog']; 
echo &quot;&quot;; 
echo $saba['rating']; 
echo &quot;&quot;; 
echo $saba['date']; 
 
echo &quot;&quot;; 
} 
 
echo &quot;&quot;; 
//STOP PRINTING OUT THE DATA 
 
// Figure out the total number of results in DB: 
$total_results = mysql_result(mysql_query(&quot;SELECT COUNT(*) as Num FROM tbl_blogrev1 ORDER BY id DESC&quot;),0); 
 
// Figure out the total number of pages. Always round up using ceil() 
$total_pages = ceil($total_results / $max_results); 
 
// Build Page Number Hyperlinks 
echo &quot;Pages: &quot;; 
 
// Build Previous Link 
if($page &gt;&nbsp;1){ 
$prev = ($page - 1); 
echo &quot;<a href="http://\&quot;&quot;.$_SERVER['php_SELF'" rel="ugc nofollow">.&quot;?page=$prev\&quot;]&amp;laquo;</a> &quot;; 
} 
 
for($i = 1; $i &lt;= $total_pages; $i++){ 
if(($page) == $i){ 
echo &quot;$i &quot;; 
} else { 
echo &quot;<a href="http://\&quot;&quot;.$_SERVER['php_SELF'" rel="ugc nofollow">.&quot;?page=$i]$i</a> &quot;; 
} 
} 
 
// Build Next Link 
if($page &lt;&nbsp;$total_pages){ 
$next = ($page + 1); 
echo &quot;<a href="http://\&quot;&quot;.$_SERVER['php_SELF'" rel="ugc nofollow">.&quot;?page=$next\&quot;]&amp;raquo;</a>&quot;; 
} 
echo &quot; 
&quot;; 
 
mysql_close(); 
?&gt;
</div>

<div>
err... sorry about that, the latest upgrades to this interface mess up html in the plain text editor... 
 
let's see if this comes through right. 

<pre><code class="code-1 nolinks" id="code-121693">&lt;?php
$alphabet = array('A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z');
foreach ($alphabet as $loop_letter) {
 if ($loop_letter == $letter) { echo '&lt;B&gt;'; }
 echo &quot;&lt;A HREF=\&quot;page.php?letter=&quot; . $loop_letter . &quot;\&quot;&gt;$loop_letter&lt;/A&gt;&amp;nbsp;¦&amp;nbsp;&quot;;
 if ($loop_letter == $letter) { echo '&lt;/B&gt;'; }
}
?&gt;
</code></pre>
</div>

<div>
great that seems to be trying to work, thanks... I am still doing something screwy with my code because this drives me to a screen without info. Can you see whats wrong/missing? 
 
<a href="http://www.bucketsofpopcorn.com/getdb.php" rel="ugc">http://www.bucketsofpopcorn.com/getdb.php</a>
</div>

<div>
change page.php to getdb.php in &nbsp;the <a href="http://page.php?letter=" rel="ugc"> code.. 
 
also make the query change that I suggested at my post from 07.17.2008 at 10:39AM PDT</a>
</div>

<div>
sorry about that... I really hate that they are interepreting all tags now in the plain text mode 

<pre><code class="code-1 nolinks" id="code-121707">change page.php to getdb.php in the &lt;a href=&quot;http://page.php?letter=&quot; &gt;code..
 
also make the query change that I suggested at my post from 07.17.2008 at 10:39AM PDT
</code></pre>
</div>

<div>
still not quite right. thanks for your help 
 
&lt;!--mysql--&gt; 
&lt;?php 
if(empty($_POST)) { 
$letter = $_GET['letter']; 
$letter .= &quot;%&quot;; 
$search = $letter; 
$alphabet = array('A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z'); 
foreach ($alphabet as $loop_letter) { 
&nbsp; if ($loop_letter == $letter) { echo ''; } 
&nbsp; echo &quot;<a href="http://\&quot;getdb.php?letter=&quot;" rel="ugc nofollow">$loop_letter</a>&amp;nbsp;¦&amp;nbsp;&quot;; 
&nbsp; if ($loop_letter == $letter) { echo ''; } 
} 
 
$sdesc = &quot;*&quot;; 
$classquery = &quot;&quot;; 
} else { 
$search = $_POST['search']; 
$search = &quot;%&quot; . $search . &quot;%&quot;; 
$sdesc = &quot;%&quot; . $search . &quot;%&quot;; 
$sclass = $_POST['title']; 
$classquery = &quot;AND 'title' = CONVERT( _utf8 '&quot; . $sclass . &quot;' USING tbl_blogrev1 )&quot;; 
} 
 
 
include 'config.php'; 
include 'opendb.php'; 
// If current page number, use it 
// if not, set one! 
 
 
 
if (isset($_GET['letter'])) { 
$letter = $_GET['letter']; 
} else {$letter= false; &nbsp;} 
 
 
// Define the number of results per page 
$max_results = 5; 
 
// Figure out the limit for the query based 
// on the current page number. 
$from = (($page * $max_results) - $max_results); 
 
// Perform mysql query on only the current page number's results 
if ($letter) { 
$query &nbsp;= &quot;SELECT id, title, blog_title, blog, rating, date FROM tbl_blogrev1 
WHERE LEFT(blog_title,1) = '$letter' 
ORDER BY id desc LIMIT $offset, $rowsPerPage&quot;; 
} else { 
$query &nbsp;= &quot;SELECT id, title, blog_title, blog, rating, date FROM tbl_blogrev1 order by id desc LIMIT $offset, $rowsPerPage&quot;; 
&nbsp;} 
 
//TO PRINT OUT THE DATA 
echo &quot;&quot;; 
echo &quot;&nbsp;ID title blog_title blog rating date&quot;; 
// keeps getting the next row until there are no more to get 
while($saba = mysql_fetch_array( $result )) { 
// Print out the contents of each row into a table 
echo &quot;&quot;; 
echo $saba['id']; 
echo &quot;&quot;; 
echo $saba['title']; 
echo &quot;&quot;; 
echo $saba['blog_title']; 
echo &quot;&quot;; 
echo $saba['blog']; 
echo &quot;&quot;; 
echo $saba['rating']; 
echo &quot;&quot;; 
echo $saba['date']; 
 
echo &quot;&quot;; 
} 
 
echo &quot;&quot;; 
//STOP PRINTING OUT THE DATA 
 
// Figure out the total number of results in DB: 
$total_results = mysql_result(mysql_query(&quot;SELECT COUNT(*) as Num FROM tbl_blogrev1 ORDER BY id DESC&quot;),0); 
 
// Figure out the total number of pages. Always round up using ceil() 
$total_pages = ceil($total_results / $max_results); 
 
// Build Page Number Hyperlinks 
echo &quot;Pages: &quot;; 
 
// Build Previous Link 
if($page &gt;&nbsp;1){ 
$prev = ($page - 1); 
echo &quot;<a href="http://\&quot;&quot;.$_SERVER['php_SELF'" rel="ugc nofollow">.&quot;?page=$prev\&quot;]&amp;laquo;</a> &quot;; 
} 
 
for($i = 1; $i &lt;= $total_pages; $i++){ 
if(($page) == $i){ 
echo &quot;$i &quot;; 
} else { 
echo &quot;<a href="http://\&quot;&quot;.$_SERVER['php_SELF'" rel="ugc nofollow">.&quot;?page=$i]$i</a> &quot;; 
} 
} 
 
// Build Next Link 
if($page &lt;&nbsp;$total_pages){ 
$next = ($page + 1); 
echo &quot;<a href="http://\&quot;&quot;.$_SERVER['php_SELF'" rel="ugc nofollow">.&quot;?page=$next\&quot;]&amp;raquo;</a>&quot;; 
} 
echo &quot; 
&quot;; 
 
mysql_close(); 
?&gt; 

</div>

<div>
 

<pre><code class="code-10 nolinks" id="code-121719">if ($letter) {
$query = &quot;SELECT id, title, blog_title, blog, rating, date FROM tbl_blogrev1
WHERE LEFT(blog_title,1) = '$letter'
ORDER BY id desc LIMIT $offset, $rowsPerPage&quot;;
} else {
$query = &quot;SELECT id, title, blog_title, blog, rating, date FROM tbl_blogrev1 order by id desc LIMIT $offset, $rowsPerPage&quot;;
 }
 
$result = mysql_query($query);
 
//TO PRINT OUT THE DATA
echo &quot;&lt;table border='1'&gt;&quot;;
echo &quot;&lt;tr&gt; &lt;th&gt;ID&lt;/th&gt; &lt;th&gt;title&lt;/th&gt; &lt;th&gt;blog_title&lt;/th&gt; &lt;th&gt;blog&lt;/th&gt; &lt;th&gt;rating&lt;/th&gt; &lt;th&gt;date&lt;/th&gt;&lt;/tr&gt;&quot;;
// keeps getting the next row until there are no more to get
while($saba = mysql_fetch_array( $result )) {
// Print out the contents of each row into a table
echo &quot;&lt;tr&gt;&lt;td&gt;&quot;;
echo $saba['id'];
echo &quot;&lt;/td&gt;&lt;td&gt;&quot;;
echo $saba['title'];
echo &quot;&lt;/td&gt;&lt;td&gt;&quot;;
echo $saba['blog_title'];
echo &quot;&lt;/td&gt;&lt;td&gt;&quot;;
echo $saba['blog'];
echo &quot;&lt;/td&gt;&lt;td&gt;&quot;;
echo $saba['rating'];
echo &quot;&lt;/td&gt;&lt;td&gt;&quot;;
echo $saba['date'];
 
echo &quot;&lt;/td&gt;&lt;/tr&gt;&quot;;
}
 
echo &quot;&lt;/table&gt;&quot;;
</code></pre>
</div>

<div>
Humm still throwing errors 
 
 
&lt;?php 
if(empty($_POST)) { 
$letter = $_GET['letter']; 
$letter .= &quot;%&quot;; 
$search = $letter; 
$alphabet = array('A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z'); 
foreach ($alphabet as $loop_letter) { 
&nbsp; if ($loop_letter == $letter) { echo ''; } 
&nbsp; echo &quot;<a href="http://\&quot;getdb.php?letter=&quot;" rel="ugc nofollow">$loop_letter</a>&amp;nbsp;¦&amp;nbsp;&quot;; 
&nbsp; if ($loop_letter == $letter) { echo ''; } 
} 
 
$sdesc = &quot;*&quot;; 
$classquery = &quot;&quot;; 
} else { 
$search = $_POST['search']; 
$search = &quot;%&quot; . $search . &quot;%&quot;; 
$sdesc = &quot;%&quot; . $search . &quot;%&quot;; 
$sclass = $_POST['title']; 
$classquery = &quot;AND 'title' = CONVERT( _utf8 '&quot; . $sclass . &quot;' USING tbl_blogrev1 )&quot;; 
} 
 
 
include 'config.php'; 
include 'opendb.php'; 
// If current page number, use it 
// if not, set one! 
 
 
 
if (isset($_GET['letter'])) { 
$letter = $_GET['letter']; 
} else {$letter= false; &nbsp;} 
 
 
// Define the number of results per page 
$max_results = 5; 
 
// Figure out the limit for the query based 
// on the current page number. 
$from = (($page * $max_results) - $max_results); 
 
// Perform mysql query on only the current page number's results 
if ($letter) { 
$query &nbsp;= &quot;SELECT id, title, blog_title, blog, rating, date FROM tbl_blogrev1 
WHERE LEFT(blog_title,1) = '$letter' 
ORDER BY id desc LIMIT $offset, $rowsPerPage&quot;; 
} else { 
$query &nbsp;= &quot;SELECT id, title, blog_title, blog, rating, date FROM tbl_blogrev1 order by id desc LIMIT $offset, $rowsPerPage&quot;; 
&nbsp;} 
&nbsp; 
$result = mysql_query($query); 
&nbsp; 
//TO PRINT OUT THE DATA 
echo &quot;&quot;; 
echo &quot;&nbsp;ID title blog_title blog rating date&quot;; 
// keeps getting the next row until there are no more to get 
while($saba = mysql_fetch_array( $result )) { 
// Print out the contents of each row into a table 
echo &quot;&quot;; 
echo $saba['id']; 
echo &quot;&quot;; 
echo $saba['title']; 
echo &quot;&quot;; 
echo $saba['blog_title']; 
echo &quot;&quot;; 
echo $saba['blog']; 
echo &quot;&quot;; 
echo $saba['rating']; 
echo &quot;&quot;; 
echo $saba['date']; 
&nbsp; 
echo &quot;&quot;; 
} 
&nbsp; 
echo &quot;&quot;; 
//STOP PRINTING OUT THE DATA 
 
// Figure out the total number of results in DB: 
$total_results = mysql_result(mysql_query(&quot;SELECT COUNT(*) as Num FROM tbl_blogrev1 ORDER BY id DESC&quot;),0); 
 
// Figure out the total number of pages. Always round up using ceil() 
$total_pages = ceil($total_results / $max_results); 
 
// Build Page Number Hyperlinks 
echo &quot;Pages: &quot;; 
 
// Build Previous Link 
if($page &gt;&nbsp;1){ 
$prev = ($page - 1); 
echo &quot;<a href="http://\&quot;&quot;.$_SERVER['php_SELF'" rel="ugc nofollow">.&quot;?page=$prev\&quot;]&amp;laquo;</a> &quot;; 
} 
 
for($i = 1; $i &lt;= $total_pages; $i++){ 
if(($page) == $i){ 
echo &quot;$i &quot;; 
} else { 
echo &quot;<a href="http://\&quot;&quot;.$_SERVER['php_SELF'" rel="ugc nofollow">.&quot;?page=$i]$i</a> &quot;; 
} 
} 
 
// Build Next Link 
if($page &lt;&nbsp;$total_pages){ 
$next = ($page + 1); 
echo &quot;<a href="http://\&quot;&quot;.$_SERVER['php_SELF'" rel="ugc nofollow">.&quot;?page=$next\&quot;]&amp;raquo;</a>&quot;; 
} 
echo &quot; 
&quot;; 
 
mysql_close(); 
?&gt; 

</div>

<div>
is there something wrong with this section? 
 
$sdesc = &quot;*&quot;; 
$classquery = &quot;&quot;; 
} else { 
$search = $_POST['search']; 
$search = &quot;%&quot; . $search . &quot;%&quot;; 
$sdesc = &quot;%&quot; . $search . &quot;%&quot;; 
$sclass = $_POST['title']; 
$classquery = &quot;AND 'title' = CONVERT( _utf8 '&quot; . $sclass . &quot;' USING tbl_blogrev1 )&quot;; 
} 

</div>

<div>
immediately below the $result &nbsp;= ... line, add this: 
 
if (mysql_errno() != 0 ) { 
&nbsp; echo mysql_errno() . ' ' . mysql_error(); 
&nbsp; exit(0); 
} 
 
 
there must be something off in the query syntax
</div>

<div>
different error 
 
<a href="http://www.bucketsofpopcorn.com/getdb.php" rel="ugc">http://www.bucketsofpopcorn.com/getdb.php</a> 
 
&lt;?php 
if(empty($_POST)) { 
$letter = $_GET['letter']; 
$letter .= &quot;%&quot;; 
$search = $letter; 
$alphabet = array('A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z'); 
foreach ($alphabet as $loop_letter) { 
&nbsp; if ($loop_letter == $letter) { echo ''; } 
&nbsp; echo &quot;<a href="http://\&quot;getdb.php?letter=&quot;" rel="ugc nofollow">$loop_letter</a>&amp;nbsp;¦&amp;nbsp;&quot;; 
&nbsp; if ($loop_letter == $letter) { echo ''; } 
} 
 
$sdesc = &quot;*&quot;; 
$classquery = &quot;&quot;; 
} else { 
$search = $_POST['search']; 
$search = &quot;%&quot; . $search . &quot;%&quot;; 
$sdesc = &quot;%&quot; . $search . &quot;%&quot;; 
$sclass = $_POST['title']; 
$classquery = &quot;AND 'title' = CONVERT( _utf8 '&quot; . $sclass . &quot;' USING tbl_blogrev1 )&quot;; 
} 
 
 
include 'config.php'; 
include 'opendb.php'; 
// If current page number, use it 
// if not, set one! 
 
 
 
if (isset($_GET['letter'])) { 
$letter = $_GET['letter']; 
} else {$letter= false; &nbsp;} 
 
 
// Define the number of results per page 
$max_results = 5; 
 
// Figure out the limit for the query based 
// on the current page number. 
$from = (($page * $max_results) - $max_results); 
 
// Perform mysql query on only the current page number's results 
if ($letter) { 
$query &nbsp;= &quot;SELECT id, title, blog_title, blog, rating, date FROM tbl_blogrev1 
WHERE LEFT(blog_title,1) = '$letter' 
ORDER BY id desc LIMIT $offset, $rowsPerPage&quot;; 
} else { 
$query &nbsp;= &quot;SELECT id, title, blog_title, blog, rating, date FROM tbl_blogrev1 order by id desc LIMIT $offset, $rowsPerPage&quot;; 
&nbsp;} 
&nbsp; 
$result = mysql_query($query); 
if (mysql_errno() != 0 ) { 
&nbsp; echo mysql_errno() . ' ' . mysql_error(); 
&nbsp; exit(0); 
} 
&nbsp; 
//TO PRINT OUT THE DATA 
echo &quot;&quot;; 
echo &quot;&nbsp;ID title blog_title blog rating date&quot;; 
// keeps getting the next row until there are no more to get 
while($saba = mysql_fetch_array( $result )) { 
// Print out the contents of each row into a table 
echo &quot;&quot;; 
echo $saba['id']; 
echo &quot;&quot;; 
echo $saba['title']; 
echo &quot;&quot;; 
echo $saba['blog_title']; 
echo &quot;&quot;; 
echo $saba['blog']; 
echo &quot;&quot;; 
echo $saba['rating']; 
echo &quot;&quot;; 
echo $saba['date']; 
&nbsp; 
echo &quot;&quot;; 
} 
&nbsp; 
echo &quot;&quot;; 
//STOP PRINTING OUT THE DATA 
 
// Figure out the total number of results in DB: 
$total_results = mysql_result(mysql_query(&quot;SELECT COUNT(*) as Num FROM tbl_blogrev1 ORDER BY id DESC&quot;),0); 
 
// Figure out the total number of pages. Always round up using ceil() 
$total_pages = ceil($total_results / $max_results); 
 
// Build Page Number Hyperlinks 
echo &quot;Pages: &quot;; 
 
// Build Previous Link 
if($page &gt;&nbsp;1){ 
$prev = ($page - 1); 
echo &quot;<a href="http://\&quot;&quot;.$_SERVER['php_SELF'" rel="ugc nofollow">.&quot;?page=$prev\&quot;]&amp;laquo;</a> &quot;; 
} 
 
for($i = 1; $i &lt;= $total_pages; $i++){ 
if(($page) == $i){ 
echo &quot;$i &quot;; 
} else { 
echo &quot;<a href="http://\&quot;&quot;.$_SERVER['php_SELF'" rel="ugc nofollow">.&quot;?page=$i]$i</a> &quot;; 
} 
} 
 
// Build Next Link 
if($page &lt;&nbsp;$total_pages){ 
$next = ($page + 1); 
echo &quot;<a href="http://\&quot;&quot;.$_SERVER['php_SELF'" rel="ugc nofollow">.&quot;?page=$next\&quot;]&amp;raquo;</a>&quot;; 
} 
echo &quot; 
&quot;; 
 
mysql_close(); 
?&gt;
</div>

<div>
well you made a change that i did not ask you to make... 
you added a '%' to the end of the letter variable and didn't mention this 
 
change your query block to this: 
 
if ($letter) { 
$query &nbsp;= &quot;SELECT id, title, blog_title, blog, rating, date FROM tbl_blogrev1 
WHERE blog_title LIKE &nbsp;'$letter' 
ORDER BY id desc LIMIT $offset, $rowsPerPage&quot;; 
} else { 
$query &nbsp;= &quot;SELECT id, title, blog_title, blog, rating, date FROM tbl_blogrev1 order by id desc LIMIT $offset, $rowsPerPage&quot;; 
&nbsp;} 
 
and it should be running
</div>

<div>
still an error... your code looks right to me for what little I can see it still throws an error? 
 
 
&lt;?php 
if(empty($_POST)) { 
$letter = $_GET['letter']; 
$letter .= &quot;%&quot;; 
$search = $letter; 
$alphabet = array('A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z'); 
foreach ($alphabet as $loop_letter) { 
&nbsp; if ($loop_letter == $letter) { echo ''; } 
&nbsp; echo &quot;<a href="http://\&quot;getdb.php?letter=&quot;" rel="ugc nofollow">$loop_letter</a>&amp;nbsp;¦&amp;nbsp;&quot;; 
&nbsp; if ($loop_letter == $letter) { echo ''; } 
} 
 
$sdesc = &quot;*&quot;; 
$classquery = &quot;&quot;; 
} else { 
$search = $_POST['search']; 
$search = &quot;%&quot; . $search . &quot;%&quot;; 
$sdesc = &quot;%&quot; . $search . &quot;%&quot;; 
$sclass = $_POST['title']; 
$classquery = &quot;AND 'blog_title' = CONVERT( _utf8 '&quot; . $sclass . &quot;' USING tbl_blogrev1 )&quot;; 
} 
 
 
include 'config.php'; 
include 'opendb.php'; 
// If current page number, use it 
// if not, set one! 
 
 
 
if (isset($_GET['letter'])) { 
$letter = $_GET['letter']; 
} else {$letter= false; &nbsp;} 
 
 
// Define the number of results per page 
$max_results = 5; 
 
// Figure out the limit for the query based 
// on the current page number. 
$from = (($page * $max_results) - $max_results); 
 
// Perform mysql query on only the current page number's results 
if ($letter) { 
$query &nbsp;= &quot;SELECT id, title, blog_title, blog, rating, date FROM tbl_blogrev1 
WHERE blog_title LIKE &nbsp;'$letter' 
ORDER BY id desc LIMIT $offset, $rowsPerPage&quot;; 
} else { 
$query &nbsp;= &quot;SELECT id, title, blog_title, blog, rating, date FROM tbl_blogrev1 order by id desc LIMIT $offset, $rowsPerPage&quot;; 
&nbsp;} 
 
&nbsp; 
$result = mysql_query($query); 
if (mysql_errno() != 0 ) { 
&nbsp; echo mysql_errno() . ' ' . mysql_error(); 
&nbsp; exit(0); 
} 
&nbsp; 
//TO PRINT OUT THE DATA 
echo &quot;&quot;; 
echo &quot;&nbsp;ID title blog_title blog rating date&quot;; 
// keeps getting the next row until there are no more to get 
while($saba = mysql_fetch_array( $result )) { 
// Print out the contents of each row into a table 
echo &quot;&quot;; 
echo $saba['id']; 
echo &quot;&quot;; 
echo $saba['title']; 
echo &quot;&quot;; 
echo $saba['blog_title']; 
echo &quot;&quot;; 
echo $saba['blog']; 
echo &quot;&quot;; 
echo $saba['rating']; 
echo &quot;&quot;; 
echo $saba['date']; 
&nbsp; 
echo &quot;&quot;; 
} 
&nbsp; 
echo &quot;&quot;; 
//STOP PRINTING OUT THE DATA 
 
// Figure out the total number of results in DB: 
$total_results = mysql_result(mysql_query(&quot;SELECT COUNT(*) as Num FROM tbl_blogrev1 ORDER BY id DESC&quot;),0); 
 
// Figure out the total number of pages. Always round up using ceil() 
$total_pages = ceil($total_results / $max_results); 
 
// Build Page Number Hyperlinks 
echo &quot;Pages: &quot;; 
 
// Build Previous Link 
if($page &gt;&nbsp;1){ 
$prev = ($page - 1); 
echo &quot;<a href="http://\&quot;&quot;.$_SERVER['php_SELF'" rel="ugc nofollow">.&quot;?page=$prev\&quot;]&amp;laquo;</a> &quot;; 
} 
 
for($i = 1; $i &lt;= $total_pages; $i++){ 
if(($page) == $i){ 
echo &quot;$i &quot;; 
} else { 
echo &quot;<a href="http://\&quot;&quot;.$_SERVER['php_SELF'" rel="ugc nofollow">.&quot;?page=$i]$i</a> &quot;; 
} 
} 
 
// Build Next Link 
if($page &lt;&nbsp;$total_pages){ 
$next = ($page + 1); 
echo &quot;<a href="http://\&quot;&quot;.$_SERVER['php_SELF'" rel="ugc nofollow">.&quot;?page=$next\&quot;]&amp;raquo;</a>&quot;; 
} 
echo &quot; 
&quot;; 
 
mysql_close(); 
?&gt;
</div>

<div>
$result = mysql_query($query); 
if (mysql_errno() != 0 ) { 
&nbsp; echo mysql_errno() . ' ' . mysql_error(); 
&nbsp; exit(0); 
} 
 
to 
 
$result = mysql_query($query); 
if (mysql_errno() != 0 ) { 
&nbsp; echo ' 
'; 
&nbsp; echo $query . ' 
'; 
&nbsp; echo mysql_errno() . ' ' . mysql_error(); 
&nbsp; exit(0); 
} 
so that we can see the query 

</div>

<div>
<a href="http://www.bucketsofpopcorn.com/getdb.php" rel="ugc">http://www.bucketsofpopcorn.com/getdb.php</a>
</div>

<div>
you are not setting offset to a value 
 
you took out: 
 
$offset = ($pageNum - 1) * $rowsPerPage; 
 

</div>

<div>
still no 
 
&lt;?php 
if(empty($_POST)) { 
$letter = $_GET['letter']; 
$letter .= &quot;%&quot;; 
$search = $letter; 
$alphabet = array('A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z'); 
foreach ($alphabet as $loop_letter) { 
&nbsp; if ($loop_letter == $letter) { echo ''; } 
&nbsp; echo &quot;<a href="http://\&quot;getdb.php?letter=&quot;" rel="ugc nofollow">$loop_letter</a>&amp;nbsp;¦&amp;nbsp;&quot;; 
&nbsp; if ($loop_letter == $letter) { echo ''; } 
} 
 
$sdesc = &quot;*&quot;; 
$classquery = &quot;&quot;; 
} else { 
$search = $_POST['search']; 
$search = &quot;%&quot; . $search . &quot;%&quot;; 
$sdesc = &quot;%&quot; . $search . &quot;%&quot;; 
$sclass = $_POST['title']; 
$classquery = &quot;AND 'blog_title' = CONVERT( _utf8 '&quot; . $sclass . &quot;' USING tbl_blogrev1 )&quot;; 
} 
 
 
include 'config.php'; 
include 'opendb.php'; 
// If current page number, use it 
// if not, set one! 
 
 
 
if (isset($_GET['letter'])) { 
$letter = $_GET['letter']; 
} else {$letter= false; &nbsp;} 
 
 
// Define the number of results per page 
$max_results = 5; 
 
// Figure out the limit for the query based 
// on the current page number. 
$from = (($page * $max_results) - $max_results); 
 
$offset = ($pageNum - 1) * $rowsPerPage; 
 
// Perform mysql query on only the current page number's results 
if ($letter) { 
$query &nbsp;= &quot;SELECT id, title, blog_title, blog, rating, date FROM tbl_blogrev1 
WHERE blog_title LIKE &nbsp;'$letter' 
ORDER BY id desc LIMIT $offset, $rowsPerPage&quot;; 
} else { 
$query &nbsp;= &quot;SELECT id, title, blog_title, blog, rating, date FROM tbl_blogrev1 order by id desc LIMIT $offset, $rowsPerPage&quot;; 
&nbsp;} 
 
&nbsp; 
$result = mysql_query($query); 
if (mysql_errno() != 0 ) { 
&nbsp;echo ' 
'; 
&nbsp;echo $query . ' 
'; 
&nbsp;echo mysql_errno() . ' ' . mysql_error(); 
&nbsp;exit(0); 
} 
&nbsp; 
//TO PRINT OUT THE DATA 
echo &quot;&quot;; 
echo &quot;&nbsp;ID title blog_title blog rating date&quot;; 
// keeps getting the next row until there are no more to get 
while($saba = mysql_fetch_array( $result )) { 
// Print out the contents of each row into a table 
echo &quot;&quot;; 
echo $saba['id']; 
echo &quot;&quot;; 
echo $saba['title']; 
echo &quot;&quot;; 
echo $saba['blog_title']; 
echo &quot;&quot;; 
echo $saba['blog']; 
echo &quot;&quot;; 
echo $saba['rating']; 
echo &quot;&quot;; 
echo $saba['date']; 
&nbsp; 
echo &quot;&quot;; 
} 
&nbsp; 
echo &quot;&quot;; 
//STOP PRINTING OUT THE DATA 
 
// Figure out the total number of results in DB: 
$total_results = mysql_result(mysql_query(&quot;SELECT COUNT(*) as Num FROM tbl_blogrev1 ORDER BY id DESC&quot;),0); 
 
// Figure out the total number of pages. Always round up using ceil() 
$total_pages = ceil($total_results / $max_results); 
 
// Build Page Number Hyperlinks 
echo &quot;Pages: &quot;; 
 
// Build Previous Link 
if($page &gt;&nbsp;1){ 
$prev = ($page - 1); 
echo &quot;<a href="http://\&quot;&quot;.$_SERVER['php_SELF'" rel="ugc nofollow">.&quot;?page=$prev\&quot;]&amp;laquo;</a> &quot;; 
} 
 
for($i = 1; $i &lt;= $total_pages; $i++){ 
if(($page) == $i){ 
echo &quot;$i &quot;; 
} else { 
echo &quot;<a href="http://\&quot;&quot;.$_SERVER['php_SELF'" rel="ugc nofollow">.&quot;?page=$i]$i</a> &quot;; 
} 
} 
 
// Build Next Link 
if($page &lt;&nbsp;$total_pages){ 
$next = ($page + 1); 
echo &quot;<a href="http://\&quot;&quot;.$_SERVER['php_SELF'" rel="ugc nofollow">.&quot;?page=$next\&quot;]&amp;raquo;</a>&quot;; 
} 
echo &quot; 
&quot;; 
 
mysql_close(); 
?&gt;
</div>

<div>
place another copy of this : 
 
if (mysql_errno() != 0 ) { 
&nbsp;echo ' 
'; 
&nbsp;echo $query . ' 
'; 
&nbsp;echo mysql_errno() . ' ' . mysql_error(); 
&nbsp;exit(0); 
} 
 
immediately above the mysql_query($query); 
 
the syntax seems correct as it stands. 

</div>

<div>
do I need this added? 
 
$rowsPerPage = 4;
</div>

<div>
added where? 
 
basically you should just rewrite the code where &nbsp;you are setting the offsets and see if that fixes it. 
 
if not, the error is elsewhere. 

</div>

<div>
&lt;?php 
if(empty($_POST)) { 
$letter = $_GET['letter']; 
$letter .= &quot;%&quot;; 
$search = $letter; 
$alphabet = array('A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z'); 
foreach ($alphabet as $loop_letter) { 
&nbsp; if ($loop_letter == $letter) { echo ''; } 
&nbsp; echo &quot;<a href="http://\&quot;getdb.php?letter=&quot;" rel="ugc nofollow">$loop_letter</a>&amp;nbsp;¦&amp;nbsp;&quot;; 
&nbsp; if ($loop_letter == $letter) { echo ''; } 
} 
 
$sdesc = &quot;*&quot;; 
$classquery = &quot;&quot;; 
} else { 
$search = $_POST['search']; 
$search = &quot;%&quot; . $search . &quot;%&quot;; 
$sdesc = &quot;%&quot; . $search . &quot;%&quot;; 
$sclass = $_POST['title']; 
$classquery = &quot;AND 'blog_title' = CONVERT( _utf8 '&quot; . $sclass . &quot;' USING tbl_blogrev1 )&quot;; 
} 
 
 
include 'config.php'; 
include 'opendb.php'; 
// If current page number, use it 
// if not, set one! 
 
 
 
if (isset($_GET['letter'])) { 
$letter = $_GET['letter']; 
} else {$letter= false; &nbsp;} 
 
 
// Define the number of results per page 
$max_results = 5; 
$rowsPerPage = 4; 
// Figure out the limit for the query based 
// on the current page number. 
$from = (($page * $max_results) - $max_results); 
 
$offset = ($pageNum - 1) * $rowsPerPage; 
 
if (mysql_errno() != 0 ) { 
echo ' 
'; 
echo $query . ' 
'; 
echo mysql_errno() . ' ' . mysql_error(); 
exit(0); 
} 
// Perform mysql query on only the current page number's results 
if ($letter) { 
$query &nbsp;= &quot;SELECT id, title, blog_title, blog, rating, date FROM tbl_blogrev1 
WHERE blog_title LIKE &nbsp;'$letter' 
ORDER BY id desc LIMIT $offset, $rowsPerPage&quot;; 
} else { 
$query &nbsp;= &quot;SELECT id, title, blog_title, blog, rating, date FROM tbl_blogrev1 order by id desc LIMIT $offset, $rowsPerPage&quot;; 
&nbsp;} 
 
&nbsp; 
$result = mysql_query($query); 
if (mysql_errno() != 0 ) { 
&nbsp;echo ' 
'; 
&nbsp;echo $query . ' 
'; 
&nbsp;echo mysql_errno() . ' ' . mysql_error(); 
&nbsp;exit(0); 
} 
&nbsp; 
//TO PRINT OUT THE DATA 
echo &quot;&quot;; 
echo &quot;&nbsp;ID title blog_title blog rating date&quot;; 
// keeps getting the next row until there are no more to get 
while($saba = mysql_fetch_array( $result )) { 
// Print out the contents of each row into a table 
echo &quot;&quot;; 
echo $saba['id']; 
echo &quot;&quot;; 
echo $saba['title']; 
echo &quot;&quot;; 
echo $saba['blog_title']; 
echo &quot;&quot;; 
echo $saba['blog']; 
echo &quot;&quot;; 
echo $saba['rating']; 
echo &quot;&quot;; 
echo $saba['date']; 
&nbsp; 
echo &quot;&quot;; 
} 
&nbsp; 
echo &quot;&quot;; 
//STOP PRINTING OUT THE DATA 
 
// Figure out the total number of results in DB: 
$total_results = mysql_result(mysql_query(&quot;SELECT COUNT(*) as Num FROM tbl_blogrev1 ORDER BY id DESC&quot;),0); 
 
// Figure out the total number of pages. Always round up using ceil() 
$total_pages = ceil($total_results / $max_results); 
 
// Build Page Number Hyperlinks 
echo &quot;Pages: &quot;; 
 
// Build Previous Link 
if($page &gt;&nbsp;1){ 
$prev = ($page - 1); 
echo &quot;<a href="http://\&quot;&quot;.$_SERVER['php_SELF'" rel="ugc nofollow">.&quot;?page=$prev\&quot;]&amp;laquo;</a> &quot;; 
} 
 
for($i = 1; $i &lt;= $total_pages; $i++){ 
if(($page) == $i){ 
echo &quot;$i &quot;; 
} else { 
echo &quot;<a href="http://\&quot;&quot;.$_SERVER['php_SELF'" rel="ugc nofollow">.&quot;?page=$i]$i</a> &quot;; 
} 
} 
 
// Build Next Link 
if($page &lt;&nbsp;$total_pages){ 
$next = ($page + 1); 
echo &quot;<a href="http://\&quot;&quot;.$_SERVER['php_SELF'" rel="ugc nofollow">.&quot;?page=$next\&quot;]&amp;raquo;</a>&quot;; 
} 
echo &quot; 
&quot;; 
 
mysql_close(); 
?&gt; 

</div>

<div>
you are never using the variable $from ... 
 
you don't need to ask me whether you need to add something. &nbsp;did adding it make it work? 

</div>

<div>
no I took it back out it just threw a different error. 
</div>

<div>
good point where would I put $from
</div>

<div>
I don't know. &nbsp;I didn't write that. 
 
&nbsp;you may need to backtick every identifier in the sql statement: 
 
SELECT id, title, blog_title, blog, rating, date FROM tbl_blogrev1 order by id desc LIMIT 0, &nbsp;1064 
 
to 
 
SELECT `id`, `title`, `blog_title`, `blog`, `rating`, `date` FROM `tbl_blogrev1` order by `id` desc LIMIT 0, &nbsp;1064 

</div>

<div>
Its strange because this error makes it look like it is creating the correct query. 
 
SELECT id, title, blog_title, blog, rating, date FROM tbl_blogrev1 WHERE blog_title LIKE 'J' ORDER BY id desc LIMIT 0, 1064 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 '' at line 3
</div>

<div>
yes, but the word DATE is also a data type in SQL, so it might be throwing an error for that reason. 

</div>

<div>
$result = mysql_query(&quot;SELECT * FROM saba ORDER BY name DESC LIMIT $from, $max_results&quot;) 
or die(mysql_error()); 
 
this is where the from statement was used before
</div>

<div>
okay and that's not a query in the page we are looking at now... so i don't see what relevance it has. 

</div>

<div>
true. its not needed anymore
</div>

<div>
I cant see where we set a value to this 
 
$rowsPerPage
</div>

<div>
Are you not using this portion of code that you showed me? 
 
// Define the number of results per page 
$max_results = 5; 
$rowsPerPage = 4; 
// Figure out the limit for the query based 
// on the current page number. 
$from = (($page * $max_results) - $max_results); 
 
$offset = ($pageNum - 1) * $rowsPerPage; 
 
if (mysql_errno() != 0 ) { 
echo ' 
'; 
echo $query . ' 
'; 
echo mysql_errno() . ' ' . mysql_error(); 
exit(0); 
} 
// Perform mysql query on only the current page number's results 
if ($letter) { 
$query &nbsp;= &quot;SELECT id, title, blog_title, blog, rating, date FROM tbl_blogrev1 
WHERE blog_title LIKE &nbsp;'$letter' 
ORDER BY id desc LIMIT $offset, $rowsPerPage&quot;; 
} else { 
$query &nbsp;= &quot;SELECT id, title, blog_title, blog, rating, date FROM tbl_blogrev1 order by id desc LIMIT $offset, $rowsPerPage&quot;; 
&nbsp;} 

</div>

<div>
no this is the entire code where is stands... I think I fubard the whole thing... sorry I am a newbie to php 
 
&lt;!--mysql--&gt; 
&lt;?php 
if(empty($_POST)) { 
$letter = $_GET['letter']; 
$letter .= &quot;%&quot;; 
$search = $letter; 
$alphabet = array('A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z'); 
foreach ($alphabet as $loop_letter) { 
&nbsp; if ($loop_letter == $letter) { echo ''; } 
&nbsp; echo &quot;<a href="http://\&quot;getdb.php?letter=&quot;" rel="ugc nofollow">$loop_letter</a>&amp;nbsp;¦&amp;nbsp;&quot;; 
&nbsp; if ($loop_letter == $letter) { echo ''; } 
} 
 
$sdesc = &quot;*&quot;; 
$classquery = &quot;&quot;; 
} else { 
$search = $_POST['search']; 
$search = &quot;%&quot; . $search . &quot;%&quot;; 
$sdesc = &quot;%&quot; . $search . &quot;%&quot;; 
$sclass = $_POST['title']; 
$classquery = &quot;AND 'blog_title' = CONVERT( _utf8 '&quot; . $sclass . &quot;' USING tbl_blogrev1 )&quot;; 
} 
 
 
include 'config.php'; 
include 'opendb.php'; 
// If current page number, use it 
// if not, set one! 
 
 
 
if (isset($_GET['letter'])) { 
$letter = $_GET['letter']; 
} else {$letter= false; &nbsp;} 
 
 
// Define the number of results per page 
$max_results = 5; 
 
// Figure out the limit for the query based 
// on the current page number. 
 
$offset = ($pageNum - 1) * $rowsPerPage; 
 
if (mysql_errno() != 0 ) { 
echo ' 
'; 
echo $query . ' 
'; 
echo mysql_errno() . ' ' . mysql_error(); 
exit(0); 
} 
// Perform mysql query on only the current page number's results 
if ($letter) { 
$query &nbsp;= &quot;SELECT id, title, blog_title, blog, rating, date FROM tbl_blogrev1 
WHERE blog_title LIKE &nbsp;'$letter' 
ORDER BY id desc LIMIT $offset, $rowsPerPage&quot;; 
} else { 
$query &nbsp;= &quot;SELECT id, title, blog_title, blog, rating, date FROM tbl_blogrev1 order by id desc LIMIT $offset, $rowsPerPage&quot;; 
&nbsp;} 
 
&nbsp; 
$result = mysql_query($query); 
if (mysql_errno() != 0 ) { 
&nbsp;echo ' 
'; 
&nbsp;echo $query . ' 
'; 
&nbsp;echo mysql_errno() . ' ' . mysql_error(); 
&nbsp;exit(0); 
} 
&nbsp; 
//TO PRINT OUT THE DATA 
echo &quot;&quot;; 
echo &quot;&nbsp;ID title blog_title blog rating date&quot;; 
// keeps getting the next row until there are no more to get 
while($saba = mysql_fetch_array( $result )) { 
// Print out the contents of each row into a table 
echo &quot;&quot;; 
echo $saba['id']; 
echo &quot;&quot;; 
echo $saba['title']; 
echo &quot;&quot;; 
echo $saba['blog_title']; 
echo &quot;&quot;; 
echo $saba['blog']; 
echo &quot;&quot;; 
echo $saba['rating']; 
echo &quot;&quot;; 
echo $saba['date']; 
&nbsp; 
echo &quot;&quot;; 
} 
&nbsp; 
echo &quot;&quot;; 
//STOP PRINTING OUT THE DATA 
 
// Figure out the total number of results in DB: 
$total_results = mysql_result(mysql_query(&quot;SELECT COUNT(*) as Num FROM tbl_blogrev1 ORDER BY id DESC&quot;),0); 
 
// Figure out the total number of pages. Always round up using ceil() 
$total_pages = ceil($total_results / $max_results); 
 
// Build Page Number Hyperlinks 
echo &quot;Pages: &quot;; 
 
// Build Previous Link 
if($page &gt;&nbsp;1){ 
$prev = ($page - 1); 
echo &quot;<a href="http://\&quot;&quot;.$_SERVER['php_SELF'" rel="ugc nofollow">.&quot;?page=$prev\&quot;]&amp;laquo;</a> &quot;; 
} 
 
for($i = 1; $i &lt;= $total_pages; $i++){ 
if(($page) == $i){ 
echo &quot;$i &quot;; 
} else { 
echo &quot;<a href="http://\&quot;&quot;.$_SERVER['php_SELF'" rel="ugc nofollow">.&quot;?page=$i]$i</a> &quot;; 
} 
} 
 
// Build Next Link 
if($page &lt;&nbsp;$total_pages){ 
$next = ($page + 1); 
echo &quot;<a href="http://\&quot;&quot;.$_SERVER['php_SELF'" rel="ugc nofollow">.&quot;?page=$next\&quot;]&amp;raquo;</a>&quot;; 
} 
echo &quot; 
&quot;; 
 
mysql_close(); 
?&gt;
</div>

<div>
in the code you have up there as of 2:45EDT, you have no value set for $rowsPerPage 
 
the number 1064 is the syntax error that the MySQL db is returning. 
 

</div>

<div>
immediately beneath: 
 
$max_results = 5; 
 
type: 
$rowsPerPage = 5; 

</div>

<div>
ok I added it back in and the error has changed. 
 
&lt;?php 
if(empty($_POST)) { 
$letter = $_GET['letter']; 
$letter .= &quot;%&quot;; 
$search = $letter; 
$alphabet = array('A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z'); 
foreach ($alphabet as $loop_letter) { 
&nbsp; if ($loop_letter == $letter) { echo ''; } 
&nbsp; echo &quot;<a href="http://\&quot;getdb.php?letter=&quot;" rel="ugc nofollow">$loop_letter</a>&amp;nbsp;¦&amp;nbsp;&quot;; 
&nbsp; if ($loop_letter == $letter) { echo ''; } 
} 
 
$sdesc = &quot;*&quot;; 
$classquery = &quot;&quot;; 
} else { 
$search = $_POST['search']; 
$search = &quot;%&quot; . $search . &quot;%&quot;; 
$sdesc = &quot;%&quot; . $search . &quot;%&quot;; 
$sclass = $_POST['title']; 
$classquery = &quot;AND 'blog_title' = CONVERT( _utf8 '&quot; . $sclass . &quot;' USING tbl_blogrev1 )&quot;; 
} 
 
 
include 'config.php'; 
include 'opendb.php'; 
// If current page number, use it 
// if not, set one! 
 
 
 
if (isset($_GET['letter'])) { 
$letter = $_GET['letter']; 
} else {$letter= false; &nbsp;} 
 
 
// Define the number of results per page 
$max_results = 5; 
$rowsPerPage = 4; 
// Figure out the limit for the query based 
// on the current page number. 
 
$offset = ($pageNum - 1) * $rowsPerPage; 
 
if (mysql_errno() != 0 ) { 
echo ' 
'; 
echo $query . ' 
'; 
echo mysql_errno() . ' ' . mysql_error(); 
exit(0); 
} 
// Perform mysql query on only the current page number's results 
if ($letter) { 
$query &nbsp;= &quot;SELECT id, title, blog_title, blog, rating, date FROM tbl_blogrev1 
WHERE blog_title LIKE &nbsp;'$letter' 
ORDER BY id desc LIMIT $offset, $rowsPerPage&quot;; 
} else { 
$query &nbsp;= &quot;SELECT id, title, blog_title, blog, rating, date FROM tbl_blogrev1 order by id desc LIMIT $offset, $rowsPerPage&quot;; 
&nbsp;} 
 
&nbsp; 
$result = mysql_query($query); 
if (mysql_errno() != 0 ) { 
&nbsp;echo ' 
'; 
&nbsp;echo $query . ' 
'; 
&nbsp;echo mysql_errno() . ' ' . mysql_error(); 
&nbsp;exit(0); 
} 
&nbsp; 
//TO PRINT OUT THE DATA 
echo &quot;&quot;; 
echo &quot;&nbsp;ID title blog_title blog rating date&quot;; 
// keeps getting the next row until there are no more to get 
while($saba = mysql_fetch_array( $result )) { 
// Print out the contents of each row into a table 
echo &quot;&quot;; 
echo $saba['id']; 
echo &quot;&quot;; 
echo $saba['title']; 
echo &quot;&quot;; 
echo $saba['blog_title']; 
echo &quot;&quot;; 
echo $saba['blog']; 
echo &quot;&quot;; 
echo $saba['rating']; 
echo &quot;&quot;; 
echo $saba['date']; 
&nbsp; 
echo &quot;&quot;; 
} 
&nbsp; 
echo &quot;&quot;; 
//STOP PRINTING OUT THE DATA 
 
// Figure out the total number of results in DB: 
$total_results = mysql_result(mysql_query(&quot;SELECT COUNT(*) as Num FROM tbl_blogrev1 ORDER BY id DESC&quot;),0); 
 
// Figure out the total number of pages. Always round up using ceil() 
$total_pages = ceil($total_results / $max_results); 
 
// Build Page Number Hyperlinks 
echo &quot;Pages: &quot;; 
 
// Build Previous Link 
if($page &gt;&nbsp;1){ 
$prev = ($page - 1); 
echo &quot;<a href="http://\&quot;&quot;.$_SERVER['php_SELF'" rel="ugc nofollow">.&quot;?page=$prev\&quot;]&amp;laquo;</a> &quot;; 
} 
 
for($i = 1; $i &lt;= $total_pages; $i++){ 
if(($page) == $i){ 
echo &quot;$i &quot;; 
} else { 
echo &quot;<a href="http://\&quot;&quot;.$_SERVER['php_SELF'" rel="ugc nofollow">.&quot;?page=$i]$i</a> &quot;; 
} 
} 
 
// Build Next Link 
if($page &lt;&nbsp;$total_pages){ 
$next = ($page + 1); 
echo &quot;<a href="http://\&quot;&quot;.$_SERVER['php_SELF'" rel="ugc nofollow">.&quot;?page=$next\&quot;]&amp;raquo;</a>&quot;; 
} 
echo &quot; 
&quot;; 
 
mysql_close(); 
?&gt;
</div>

<div>
$offset = ($pageNum - 1) * $rowsPerPage; 
 
to 
$offset = ($pageNum ) * $rowsPerPage; 

</div>

<div>
ok were getting somewhere. Thanks for your patience. the code isnt broken now its just not displaying results
</div>

<div>
this block 
 
if (isset($_GET['letter'])) { 
$letter = $_GET['letter']; 
} else {$letter= false; &nbsp;} 
 
 
should be in the 
 
if (empty($_POST) ... 
 
block 
 
 
and you shouldn't append the % immediately : 
 
 
if(empty($_POST)) { 
 
if (isset($_GET['letter'])) { 
$letter = $_GET['letter']; 
} else {$letter= false; &nbsp;} 
 
$search = $letter; 
$alphabet = array('A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z'); 
foreach ($alphabet as $loop_letter) { 
&nbsp; if ($loop_letter == $letter) { echo ''; } 
&nbsp; echo &quot;$loop_letter&amp;nbsp;¦&amp;nbsp;&quot;; 
&nbsp; if ($loop_letter == $letter) { echo ''; } 
} 
 
$letter .= &quot;%&quot;; 
} 

</div>

<div>
I get a syntax error 
 
&lt;?php 
 
if(empty($_POST)) { 
 
if (isset($_GET['letter'])) { 
$letter = $_GET['letter']; 
} else {$letter= false; &nbsp;} 
 
$search = $letter; 
$alphabet = array('A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z'); 
foreach ($alphabet as $loop_letter) { 
&nbsp;if ($loop_letter == $letter) { echo ''; } 
&nbsp;echo &quot;$loop_letter&amp;nbsp;¦&amp;nbsp;&quot;; 
&nbsp;if ($loop_letter == $letter) { echo ''; } 
} 
 
$letter .= &quot;%&quot;; 
} 
 
$sdesc = &quot;*&quot;; 
$classquery = &quot;&quot;; 
} else { 
$search = $_POST['search']; 
$search = &quot;%&quot; . $search . &quot;%&quot;; 
$sdesc = &quot;%&quot; . $search . &quot;%&quot;; 
$sclass = $_POST['title']; 
$classquery = &quot;AND 'blog_title' = CONVERT( _utf8 '&quot; . $sclass . &quot;' USING tbl_blogrev1 )&quot;; 
} 
 
 
include 'config.php'; 
include 'opendb.php'; 
// If current page number, use it 
// if not, set one! 
 
 
 
if (isset($_GET['letter'])) { 
$letter = $_GET['letter']; 
} else {$letter= false; &nbsp;} 
 
 
// Define the number of results per page 
$max_results = 5; 
$rowsPerPage = 5; 
// Figure out the limit for the query based 
// on the current page number. 
 
$offset = ($pageNum ) * $rowsPerPage; 
 
if (mysql_errno() != 0 ) { 
echo ' 
'; 
echo $query . ' 
'; 
echo mysql_errno() . ' ' . mysql_error(); 
exit(0); 
} 
// Perform mysql query on only the current page number's results 
if ($letter) { 
$query &nbsp;= &quot;SELECT id, title, blog_title, blog, rating, date FROM tbl_blogrev1 
WHERE blog_title LIKE &nbsp;'$letter' 
ORDER BY id desc LIMIT $offset, $rowsPerPage&quot;; 
} else { 
$query &nbsp;= &quot;SELECT id, title, blog_title, blog, rating, date FROM tbl_blogrev1 order by id desc LIMIT $offset, $rowsPerPage&quot;; 
&nbsp;} 
 
&nbsp; 
$result = mysql_query($query); 
if (mysql_errno() != 0 ) { 
&nbsp;echo ' 
'; 
&nbsp;echo $query . ' 
'; 
&nbsp;echo mysql_errno() . ' ' . mysql_error(); 
&nbsp;exit(0); 
} 
&nbsp; 
//TO PRINT OUT THE DATA 
echo &quot;&quot;; 
echo &quot;&nbsp;ID title blog_title blog rating date&quot;; 
// keeps getting the next row until there are no more to get 
while($saba = mysql_fetch_array( $result )) { 
// Print out the contents of each row into a table 
echo &quot;&quot;; 
echo $saba['id']; 
echo &quot;&quot;; 
echo $saba['title']; 
echo &quot;&quot;; 
echo $saba['blog_title']; 
echo &quot;&quot;; 
echo $saba['blog']; 
echo &quot;&quot;; 
echo $saba['rating']; 
echo &quot;&quot;; 
echo $saba['date']; 
&nbsp; 
echo &quot;&quot;; 
} 
&nbsp; 
echo &quot;&quot;; 
//STOP PRINTING OUT THE DATA 
 
// Figure out the total number of results in DB: 
$total_results = mysql_result(mysql_query(&quot;SELECT COUNT(*) as Num FROM tbl_blogrev1 ORDER BY id DESC&quot;),0); 
 
// Figure out the total number of pages. Always round up using ceil() 
$total_pages = ceil($total_results / $max_results); 
 
// Build Page Number Hyperlinks 
echo &quot;Pages: &quot;; 
 
// Build Previous Link 
if($page &gt;&nbsp;1){ 
$prev = ($page - 1); 
echo &quot;<a href="http://\&quot;&quot;.$_SERVER['php_SELF'" rel="ugc nofollow">.&quot;?page=$prev\&quot;]&amp;laquo;</a> &quot;; 
} 
 
for($i = 1; $i &lt;= $total_pages; $i++){ 
if(($page) == $i){ 
echo &quot;$i &quot;; 
} else { 
echo &quot;<a href="http://\&quot;&quot;.$_SERVER['php_SELF'" rel="ugc nofollow">.&quot;?page=$i]$i</a> &quot;; 
} 
} 
 
// Build Next Link 
if($page &lt;&nbsp;$total_pages){ 
$next = ($page + 1); 
echo &quot;<a href="http://\&quot;&quot;.$_SERVER['php_SELF'" rel="ugc nofollow">.&quot;?page=$next\&quot;]&amp;raquo;</a>&quot;; 
} 
echo &quot; 
&quot;; 
 
mysql_close(); 
?&gt; 
 

</div>

<div>
Parse error: syntax error, unexpected '}' in /home/content/r/o/b/robbinsmta/html/Buckets/getdb.php on line 24 
<a href="http://www.bucketsofpopcorn.com/getdb.php" rel="ugc">http://www.bucketsofpopcorn.com/getdb.php</a> 

</div>

<div>
this is where the code stands 
 
&lt;?php 
 
if(empty($_POST)) { 
 
if (isset($_GET['letter'])) { 
$letter = $_GET['letter']; 
} else {$letter= false; &nbsp;} 
 
$search = $letter; 
$alphabet = array('A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z'); 
foreach ($alphabet as $loop_letter) { 
&nbsp;if ($loop_letter == $letter) { echo ''; } 
&nbsp;echo &quot;$loop_letter&amp;nbsp;¦&amp;nbsp;&quot;; 
&nbsp;if ($loop_letter == $letter) { echo ''; } 
} 
$letter .= &quot;%&quot;; 
} 
$sdesc = &quot;*&quot;; 
$classquery = &quot;&quot;; 
} else { 
$search = $_POST['search']; 
$search = &quot;%&quot; . $search . &quot;%&quot;; 
$sdesc = &quot;%&quot; . $search . &quot;%&quot;; 
$sclass = $_POST['title']; 
$classquery = &quot;AND 'blog_title' = CONVERT( _utf8 '&quot; . $sclass . &quot;' USING tbl_blogrev1 )&quot;; 
} 
 
 
include 'config.php'; 
include 'opendb.php'; 
// If current page number, use it 
// if not, set one! 
 
 
// Define the number of results per page 
$max_results = 5; 
$rowsPerPage = 5; 
// Figure out the limit for the query based 
// on the current page number. 
 
$offset = ($pageNum ) * $rowsPerPage; 
 
if (mysql_errno() != 0 ) { 
echo ' 
'; 
echo $query . ' 
'; 
echo mysql_errno() . ' ' . mysql_error(); 
exit(0); 
} 
// Perform mysql query on only the current page number's results 
if ($letter) { 
$query &nbsp;= &quot;SELECT id, title, blog_title, blog, rating, date FROM tbl_blogrev1 
WHERE blog_title LIKE &nbsp;'$letter' 
ORDER BY id desc LIMIT $offset, $rowsPerPage&quot;; 
} else { 
$query &nbsp;= &quot;SELECT id, title, blog_title, blog, rating, date FROM tbl_blogrev1 order by id desc LIMIT $offset, $rowsPerPage&quot;; 
&nbsp;} 
 
&nbsp; 
$result = mysql_query($query); 
if (mysql_errno() != 0 ) { 
&nbsp;echo ' 
'; 
&nbsp;echo $query . ' 
'; 
&nbsp;echo mysql_errno() . ' ' . mysql_error(); 
&nbsp;exit(0); 
} 
&nbsp; 
//TO PRINT OUT THE DATA 
echo &quot;&quot;; 
echo &quot;&nbsp;ID title blog_title blog rating date&quot;; 
// keeps getting the next row until there are no more to get 
while($saba = mysql_fetch_array( $result )) { 
// Print out the contents of each row into a table 
echo &quot;&quot;; 
echo $saba['id']; 
echo &quot;&quot;; 
echo $saba['title']; 
echo &quot;&quot;; 
echo $saba['blog_title']; 
echo &quot;&quot;; 
echo $saba['blog']; 
echo &quot;&quot;; 
echo $saba['rating']; 
echo &quot;&quot;; 
echo $saba['date']; 
&nbsp; 
echo &quot;&quot;; 
} 
&nbsp; 
echo &quot;&quot;; 
//STOP PRINTING OUT THE DATA 
 
// Figure out the total number of results in DB: 
$total_results = mysql_result(mysql_query(&quot;SELECT COUNT(*) as Num FROM tbl_blogrev1 ORDER BY id DESC&quot;),0); 
 
// Figure out the total number of pages. Always round up using ceil() 
$total_pages = ceil($total_results / $max_results); 
 
// Build Page Number Hyperlinks 
echo &quot;Pages: &quot;; 
 
// Build Previous Link 
if($page &gt;&nbsp;1){ 
$prev = ($page - 1); 
echo &quot;<a href="http://\&quot;&quot;.$_SERVER['php_SELF'" rel="ugc nofollow">.&quot;?page=$prev\&quot;]&amp;laquo;</a> &quot;; 
} 
 
for($i = 1; $i &lt;= $total_pages; $i++){ 
if(($page) == $i){ 
echo &quot;$i &quot;; 
} else { 
echo &quot;<a href="http://\&quot;&quot;.$_SERVER['php_SELF'" rel="ugc nofollow">.&quot;?page=$i]$i</a> &quot;; 
} 
} 
 
// Build Next Link 
if($page &lt;&nbsp;$total_pages){ 
$next = ($page + 1); 
echo &quot;<a href="http://\&quot;&quot;.$_SERVER['php_SELF'" rel="ugc nofollow">.&quot;?page=$next\&quot;]&amp;raquo;</a>&quot;; 
} 
echo &quot; 
&quot;; 
 
mysql_close(); 
?&gt; 

</div>

<div>
$letter .= &quot;%&quot;; 
} 
$sdesc = &quot;*&quot;; 
 
to 
 
$letter .= &quot;%&quot;; 
$sdesc = &quot;*&quot;; 

</div>

<div>
ok everything is back up but I lost the links again 
 
<a href="http://www.bucketsofpopcorn.com/getdb.php" rel="ugc">http://www.bucketsofpopcorn.com/getdb.php</a>
</div>

<div>
the code is in one of the comments above. &nbsp;just replace the loop that goes through the letters with the one that correctly has 
</div>

<div>
ok again it functions correctly but I still dont get results from the links
</div>

<div>
wait a second, i think it actually works perfect. one sec
</div>

<div>
so if I want to pull results from multiple tables with identical fields how do I write this query? 
 
$query &nbsp;= &quot;SELECT id, title, blog_title, blog, rating, date FROM tbl_blogrev1 and tbl_blogrev2 and tbl_blogrev3 

</div>

<div>
sorry just tell me if your finished here, you have been an awesome help! 
what I want to do is pull data from multiple tables that are set up the same 
 
$query &nbsp;= &quot;SELECT id, title, blog_title, blog, rating, date FROM tbl_blogrev1 (tbl_blogrev2, tbl_blogrev3 etc) 
WHERE title LIKE &nbsp;'$letter' 
ORDER BY id desc LIMIT $offset, $rowsPerPage&quot;;
</div>

<div>
Thanks again for all your help. I am going to close this request now and open another one. Thanks again!
</div>

<div>
<div class="content wysiwyg-content">
I am trying to build a script that does alphabetical pagination by title and then breaks that down in to pagination by 5 results per page. Please help or refer me to script that works. Thanks
</div>
</div>

I am trying to build a script that does alphabetical pagination by title and then breaks that down in to pagination by 5 results per page. Please help or refer me to script that works. Thanks

php alphabetical pagination

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.