By gaurab on

I am new to drupal ,i have got a problem in the pagination.Hers is my code
drupal_add_css(drupal_get_path('module', 'news') .'/news.css', 'last', 'all', TRUE);
$breadcrumb = array();
$breadcrumb = array(l(t('Home'), ''), l(t('News'), 'client_news'));
drupal_set_breadcrumb($breadcrumb);

$news_content = '';
$limit = 5;
$query = "SELECT * FROM news";
$record_count = db_result(db_query("SELECT COUNT(*) FROM {news}"));
$result = pager_query($query,$limit,0,$record_count);

while($links = db_fetch_object($result)) {

$length_news = strlen(trim($links->news_desc));

if ($length_news > 300) {
$news_desc = substr($links->news_desc, 0, 300). '...';
} else {
$news_desc = $links->news_desc;
}

$status = ($links->is_active == 'Publish')?'Published':'Unpublished';

$news_content .= theme('news_display',
check_plain($links->news_title),
check_plain($news_desc),
l('More','news_detail/view/' . $links->id));
}
$news_content.= theme('pager', NULL,$limit, $record_count);

return $news_content;

not sure where is the problem but 5 records are displayed and the pagination is not displayed and i got the error
user warning: 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 '8' at line 1 query: 8 i

Any suggestions
Thanks

⋅ Categories: Drupal 6.x

Comments

nehajn’s picture

nehajn commented 

function uc_purchase()
{
 $sql ="SELECT * from uc_role_exp ";
      $role_per_page = 10;
      // count query
  $cq_sql ="SELECT  count(distinct oid) from uc_role_exp ";
    $result = pager_query($sql,$role_per_page,0,$cq_sql);  
           if ($result > 0)
        {
        while ($role = db_fetch_object($result)) {                
         $data .= $role->uid;  
         $data .= $role_name;  
         $data .= $st;  
             }
        }
        else {$data .= "<p>No Any Data</p>";} 
            // print paging links
	$data .= theme('pager', NULL, 5);
        return $data;
        }