<?php
	require_once dirname(dirname(__FILE__)) . "/cmsAdmin/lib/viewer_functions.php";

 /* 
  //  load records
  list($service_categoriesRecords, $service_categoriesMetaData) = getRecords(array(
       'tableName'   => 'service_categories',
	 //'where'       => " category_name = '" .getNumberFromEndOfUrl() . "'",
    //'where'       => whereRecordNumberInUrl(1),
    //'limit'       => '1',
  ));
	$service_categoriesRecord = @$service_categoriesRecords[0]; // get first record

  // show error message if no matching record is found
  if (!$service_categoriesRecord) {
    header("HTTP/1.0 404 Not Found");
    print "Record not found!";
    exit;
  }
 */ 
  list($service_titlesRecords, $service_titlesMetaData) = getRecords(array(
    'tableName'   => 'service_titles',
	//'joinTable'   => 'service_categories',
	'where'       => " category = '" .getNumberFromEndOfUrl(1) . "'",
    'perPage'     => '3',
  ));
 $service_titlesRecord = @$service_titlesRecords[0]; // get first record

  // show error message if no matching record is found
  if (!$service_titlesRecord) {
    header("HTTP/1.0 404 Not Found");
    print "Record not found!";
    exit;
  }
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
 <head>
  <title></title>
  <meta http-equiv="Content-Type" content="text/html;charset=UTF-8" />
  <style type="text/css">
    body          { font-family: arial; }
    .instructions { border: 3px solid #000; background-color: #EEE; padding: 10px; text-align: left; margin: 25px}
  </style>
 </head>
<body>
    <h2>Service Categories - List Page1</h2>
<!-- Unable to getservice_categories to display Name rather then Number -->
		<?php echo $service_categories['category_name'] ?> category_name<br />
		<?php echo $service_categories['summary'] ?> summary<br />
		<hr/>
        
<!-- PAGE LINKS -->

    <?php if ($service_titlesMetaData['prevPage']): ?>
      <a href="<?php echo $service_titlesMetaData['prevPageLink'] ?>">&lt; prev</a>
    <?php else: ?>
      &lt;&lt; prev
    <?php endif ?>

    - page <?php echo $service_titlesMetaData['page'] ?> of <?php echo $service_titlesMetaData['totalPages'] ?> -

    <?php if ($service_titlesMetaData['nextPage']): ?>
      <a href="<?php echo $service_titlesMetaData['nextPageLink'] ?>">next &gt;</a>
    <?php else: ?>
      next &gt;&gt;
    <?php endif ?>  
    <!-- &lastNum=0 -->
      <?php if ($service_titlesMetaData['invalidPageNum']): ?>
      Results page '<?php echo $service_titlesMetaData['page']?>' not found, 
      <a href="<?php echo $service_titlesMetaData['firstPageLink'] ?>">start over &gt;</a>.<br/><br/>
    <?php elseif (!$service_titlesRecords): ?>
      No records were found.<br/><br/>
    <?php endif ?>
<!-- End of Page Links -->
<hr/>
<br />

        
        	<?php foreach ($service_titlesRecords as $record): ?>   
            <?php echo "Category" ?> <?php echo $record['category'] ?><br/>
			<b><?php echo $record['service_title'] ?></b><br/>
      		<?php echo $record['description'] ?><br/><br /> 
	    	<?php endforeach ?>
         <hr/>
</body>
</html>
