$options['pageNum'] = '1'; 
$options['perPage'] = '1'; 
$options['orderBy'] = 'order';

$numFromUrl = getNumberFromEndOfUrl(); 
if (!$numFromUrl) { $numFromUrl = 5; }

$options['recordNum'] = $numFromUrl;

blog.php (shows home) 
blog.php/home 
blog.php/page1 
blog.php/page2 
blog.php/contact

$numFromUrl = getNumberFromEndOfUrl();  
if (!$numFromUrl) { $numFromUrl = 5; }

require_once "/xxx/viewer_functions.php"; 
 
// load menu items 
$options = array(); 
$options['tableName']  = 'blog'; 
$options['titleField'] = 'title'; 
$options['viewerUrl']  = '/xxx/blogPage.php'; 
$options['perPage']    = '9999'; 
$options['orderBy']    = 'order DESC, date DESC, title'; 
$options['pageNum']    = '1'; 
$options['where']      = ''; 
$options['useSeoUrls'] = '1'; 
list($listRows, $listDetails) = getListRows($options); 
 
// get record num for page content 
$numFromUrl = getNumberFromEndOfUrl(); 
if (!$numFromUrl) { 
  $lastIndex  = count($listRows) - 1; 
  $numFromUrl = $listRows[$lastIndex]['num']; // use default 
} 
 
// load page content 
$options = array(); 
$options['tableName'] = 'blog'; 
$options['recordNum'] = $numFromUrl; 
$options['where']     = ''; 
$record = getRecord($options);

require_once "/xxx/viewer_functions.php";  
  
// load menu items  
$listOptions = array();  
$listOptions['tableName']  = 'blog';  
$listOptions['titleField'] = 'title';  
$listOptions['viewerUrl']  = '/xxx/blogPage.php';  
$listOptions['perPage']    = '9999';  
$listOptions['orderBy']    = 'order DESC, date DESC, title';  
$listOptions['pageNum']    = '1';  
$listOptions['where']      = '';  
$listOptions['useSeoUrls'] = '1';  
list($listRows, $listDetails) = getListRows($listOptions);  
  
// get record num for page content  
$numFromUrl = getNumberFromEndOfUrl();  
if (!$numFromUrl) {  
  $lastIndex  = count($listRows) - 1;  
  $numFromUrl = $listRows[$lastIndex]['num']; // use default  
}  
  
// load page content  
$pageOptions = array();  
$pageOptions['tableName'] = 'blog';  
$pageOptions['recordNum'] = $numFromUrl;  
$pageOptions['where']     = '';  
$record = getRecord($pageOptions);

   <ul id="menu"> 
  <?php $numFromUrl = getNumberFromEndOfUrl(); foreach ($listRows as $record): if ($record): ?> 
  <?php if ($record['num'] == $numFromUrl): ?> 
   <li><span id="menuselected"><?php echo $record['title'] ?></span></li> 
  <?php elseif ($numFromUrl == ""): ?>  
   <li><span id="menuselected"><a href="<?php echo $record['_link'] ?>"><?php echo $record['title'] ?></a></span></li> 
  <?php else: ?> 
   <li><a href="<?php echo $record['_link'] ?>"><?php echo $record['title'] ?></a></li> 
  <?php endif ?> 
  <?php endif ?> 
  <?php endforeach ?> 
  </ul>

$listOptions['orderBy'] = '`order` ASC, date DESC, title';

<?php foreach ($listRows as $listRecord): if ($listRecord): ?> 
  ... change all $record variables to $listRecord ... 
<?php endif ?> 
<?php endforeach ?>

 <?php $username = $CURRENT_USER['username']; ?> 
<?php if ($username == 'admin'): ?> 
<a href="javascript:confirmEraseRecord('<?php echo htmlspecialchars($menu) ?>','<?php echo $record{'num'} ?>');">erase</a> 
<?php else: ?> 
-- 
<?php endif ?>