<?php header('Content-type: text/html; charset=utf-8'); ?>
<?php
  /* STEP 1: LOAD RECORDS - Copy this PHP code block near the TOP of your page */

  // load viewer library
  $libraryPath = 'cmsAdmin/lib/viewer_functions.php';
  $dirsToCheck = array('/home/colourp1/public_html/','','../','../../','../../../');
  foreach ($dirsToCheck as $dir) { if (@include_once("$dir$libraryPath")) { break; }}
  if (!function_exists('getRecords')) { die("Couldn't load viewer library, check filepath in sourcecode."); }

  // load records
  list($categoriesRecords, $categoriesMetaData) = getRecords(array(
    'tableName'   => 'categories',
  ));
  $categoriesRecord = @$categoriesRecords[0]; // get first record

  // show error message if no matching record is found
  if (!$categoriesRecord) {
    header("HTTP/1.0 404 Not Found");
    print "Record not found!";
    exit;
  }

  list($product_subcategoriesRecords, $product_subcategoriesMetaData) = getRecords(array(
    'tableName'   => 'product_subcategories',
	'orderBy'     => 'title',
  ));

?>
<!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>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE><?php echo $categoriesRecord['title'] ?></TITLE>
<LINK HREF="styles.css" REL="stylesheet" TYPE="text/css">
<SCRIPT LANGUAGE="JavaScript" TYPE="text/javascript"><!--

var image = new Array();

image[0] = 'images/background-01.jpg' ;
image[1] = 'images/background-02.jpg' ;
image[2] = 'images/background-03.jpg' ;
image[3] = 'images/background-04.jpg' ;
image[4] = 'images/background-05.jpg' ;

var index = Math.floor(Math.random() * image.length);
document.write('<style type="text/css"> td.titleLower { background-image: url('+ image[index] +') } </style>');
//-->
</SCRIPT>
</HEAD>

<BODY>
<TABLE WIDTH="1000" BORDER="0" ALIGN="CENTER" CELLPADDING="0" CELLSPACING="0">
  <TR>
    <TD COLSPAN="7" CLASS="tdWhite"><?php require_once('_include-masthead.php'); ?></TD>
  </TR>
  <TR>
    <TD CLASS="titleLower" COLSPAN="7" ALIGN="LEFT" VALIGN="TOP"><TABLE WIDTH="1000" HEIGHT="170" BORDER="0" CELLPADDING="0" CELLSPACING="0">
      <TR>
        <TD CLASS="tdLowerHeadlineCell"><H1><?php echo $categoriesRecord['title'] ?></H1></TD>
      </TR>
    </TABLE></TD>
  </TR>
  <TR>
    <TD CLASS="tdWhite"><IMG SRC="images/single-pixel.gif" WIDTH="20" HEIGHT="17"></TD>
    <TD CLASS="tdWhite"><IMG SRC="images/single-pixel.gif" WIDTH="176" HEIGHT="17"></TD>
    <TD CLASS="tdWhite"><IMG SRC="images/single-pixel.gif" WIDTH="20" HEIGHT="17"></TD>
    <TD CLASS="tdWhite"><IMG SRC="images/single-pixel.gif" WIDTH="499" HEIGHT="17"></TD>
    <TD CLASS="tdWhite"><IMG SRC="images/single-pixel.gif" WIDTH="20" HEIGHT="17"></TD>
    <TD CLASS="tdWhite"><IMG SRC="images/single-pixel.gif" WIDTH="245" HEIGHT="17"></TD>
    <TD CLASS="tdWhite"><IMG SRC="images/single-pixel.gif" WIDTH="20" HEIGHT="20"></TD>
  </TR>
  <TR>
    <TD CLASS="tdWhite">&nbsp;</TD>
    <TD CLASS="tdWhite"><TABLE WIDTH="176" BORDER="0" CELLSPACING="0" CELLPADDING="0">
      <TR>
        <TD><IMG SRC="images/single-pixel.gif" WIDTH="176" HEIGHT="3"></TD>
      </TR>
      <TR>
        <TD CLASS="tdNavbarBG"><P CLASS="pNavText01"><A HREF="index.php">Home</A></P>
          <P CLASS="pNavText01"><A HREF="about.php">About Us </A></P>
          <DIV CLASS="divNavbarON"><P CLASS="pNavText01NoRule"><A HREF="plants.php">Plants and Flowers</A></P>
            <P CLASS="pNavText02NoRule"><A HREF="plants.php"> Browse/Search</A></P>
            <P CLASS="pNavText02"><A HREF="#">Product News</A></P>
          </DIV>
          <P CLASS="pNavText01"><A HREF="index.php">Tips and Advice </A></P>
          <P CLASS="pNavText01"><A HREF="news.php">News and Events </A></P>
          <P CLASS="pNavText01"><A HREF="index.php">Fundraisers</A> </P>
          <P CLASS="pNavText01"><A HREF="index.php">Contact Us</A></P></TD>
      </TR>
      <TR>
        <TD><IMG SRC="images/single-pixel.gif" WIDTH="176" HEIGHT="15"></TD>
      </TR>
    </TABLE></TD>
    <TD CLASS="tdWhite">&nbsp;</TD>
    <TD CLASS="tdWhite">  <!-- STEP2: Display Records (Paste this where you want your records to be listed) -->
    <?php foreach ($product_subcategoriesRecords as $record): ?>
      <p><a href="<?php echo $record['_link'] ?>"><?php echo $record['title'] ?></a><br/>
      Main Category: <?php echo $record['main_category'] ?><br/>
      Light: <?php echo $record['light'] ?><br/>
      Plant Care: <?php echo $record['content'] ?><br/>
      Facts: <?php echo $record['facts'] ?><br/>

      <!-- STEP 2a: Display Uploads for field 'main_image' (Paste this anywhere inside STEP2 to display uploads) -->
        <!-- Upload Fields: num, createdTime, tableName, fieldName, recordNum, preSaveTempId, filePath, filename, extension, thumbFilePath, isImage, hasThumbnail, urlPath, width, height, thumbUrlPath, thumbWidth, thumbHeight, info1, info2, info3, info4, info5 -->
        <?php foreach ($record['main_image'] as $upload): ?>
          <?php if ($upload['hasThumbnail']): ?>
            <img src="<?php echo $upload['thumbUrlPath'] ?>" width="<?php echo $upload['thumbWidth'] ?>" height="<?php echo $upload['thumbHeight'] ?>" alt="" /><br/>

          <?php elseif ($upload['isImage']): ?>
            <img src="<?php echo $upload['urlPath'] ?>" width="<?php echo $upload['width'] ?>" height="<?php echo $upload['height'] ?>" alt="" /><br/>

          <?php else: ?>
            <a href="<?php echo $upload['urlPath'] ?>">Download <?php echo $upload['filename'] ?></a><br/>

          <?php endif ?>
        <?php endforeach ?>
      <!-- STEP2a: /Display Uploads -->


      <hr/>
    <?php endforeach ?>

    <?php if (!$product_subcategoriesRecords): ?>
      <p>No records were found!</p>
    <?php endif ?>
  <!-- /STEP2: Display Records -->
</TD><TD CLASS="tdWhite">&nbsp;</TD>
    <TD COLSPAN="2" CLASS="tdWhite"><?php require_once('_include-right-column.php'); ?></TD>
  </TR>
  <TR>
    <TD CLASS="tdWhite">&nbsp;</TD>
    <TD COLSPAN="5" CLASS="tdWhiteRuleTop"><?php require_once('_include-footer.php'); ?></TD>
    <TD CLASS="tdWhite">&nbsp;</TD>
  </TR>
</TABLE>
</BODY>
</HTML>
