<?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' 	  => "category = 'YOURCATEGORY'",
    //'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',
	//'where'       => " category = '" .getNumberFromEndOfUrl(1) . "'",
    'perPage'     => '10',
  ));
  $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>


  <!-- STEP2: Display Records (Paste this where you want your records to be listed) -->
    <h2>Service Titles - List Page Viewer1</h2>
        <a href="list.test.php?service_categories=<?php echo $service_categoriesRecord['category_name'] ?>">
		<?php echo $service_categoriesRecord['category_name'] ?></a><br />
        <?php echo $service_categoriesRecord['summary'] ?><br />
		<hr/>
        
  <!-- STEP3: Display Page Links (Paste anywhere below "Load Record List") -->
    <?php if ($service_titlesMetaData['prevPage']): ?>
      <a href="<?php echo $service_titlesMetaData['prevPageLink'] ?>">&lt;&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;&gt;</a>
    <?php else: ?>
      next &gt;&gt;
    <?php endif ?>
  <!-- /STEP3: Display 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/>
	    <?php endforeach ?>
     <hr/>
    <?php if ($service_titlesMetaData['invalidPageNum']): ?>
      Results page '<?php echo $service_titlesMetaData['page']?>' not found, 
      <a href="<?php echo $service_titlesMetaData['firstPageLink'] ?>">start over &gt;&gt;</a>.<br/><br/>
    <?php elseif (!$service_titlesRecords): ?>
      No records were found.<br/><br/>
    <?php endif ?>
  <!-- /STEP2: Display Records -->
</body>
</html>
