<?php
function example_menu() {
  $items = array();

  $items['example/notworking'] = array(
    'title' => 'Not working',
    'access arguments' => true,
    'page callback' => 'example_notworking_page'
  );
  $items['example/working'] = array(
    'title' => 'Working',
    'access arguments' => true,
    'page callback' => 'example_working_page'
  );
  
  return $items;
}

function example_notworking_page() {
  $headers = array('nid', 'status', 'title');
  $query = db_select('node', 'n')
    ->extend('PagerDefault')
    ->limit(10)
    ->extend('TableSort')
    ->orderByHeader($headers)
    ->fields('n', array('nid', 'status', 'title'));
  $results = $query->execute();
  
  foreach ($results as $node) {
    $rows[] = array(
      'class' => 'extraclassname',
      'data' => array($node->nid, $node->status, $node->title)
    );
  }

  $output['table'] = array(
    '#theme' => 'table',
    '#header' => $headers,
    '#rows' => $rows
  );

  $output['pager'] = array('#theme' => 'pager');

  return $output;
}


function example_working_page() {
  $headers = array('nid', 'status', 'title');
  $query = db_select('node', 'n')
    ->extend('PagerDefault')
    ->limit(10)
    ->extend('TableSort')
    ->orderByHeader($headers)
    ->fields('n', array('nid', 'status', 'title'));
  $results = $query->execute();
  
  foreach ($results as $node) {
    $rows[] = array(
      'class' => array('extraclassname'),
      'data' => array($node->nid, $node->status, $node->title)
    );
  }

  $output['table'] = array(
    '#theme' => 'table',
    '#header' => $headers,
    '#rows' => $rows
  );

  $output['pager'] = array('#theme' => 'pager');

  return $output;
}