// Setup the PM table header.
  $header = array(
    array('data' => t('From'), 'field' => 'u.uid'),
    array('data' => t('Subject'), 'width' => '50%', 'field' => 'n.title'),
    array('data' => t('Date'), 'field' => 'n.created', 'sort' => 'desc'),
  );

  // Query the database for the account's PMs based on the specified view.
  switch ($view) {
    case 'inbox':
      $result = pager_query("SELECT pm.nid, pm.status, u.uid, u.name, n.title, n.created FROM {pm_lite} pm LEFT JOIN {node} n ON pm.nid = n.nid LEFT JOIN {users} u ON n.uid = u.uid WHERE pm.recipient = %d". tablesort_sql($header), $limit, 0, NULL, $account->uid);
      break;

    case 'sent':
      $header[0]['data'] = t('To');
      $result = pager_query("SELECT DISTINCT pm.nid, n.title, n.created FROM {pm_lite} pm LEFT JOIN {node} n ON pm.nid = n.nid WHERE n.uid = %d". tablesort_sql($header), $limit, 0, NULL, $account->uid);
      break;
  }