<?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($product_subcategoriesRecords, $product_subcategoriesMetaData) = getRecords(array(
    'tableName'   => 'product_subcategories',
    'where'       => whereRecordNumberInUrl(1),
    'limit'       => '1',
  ));
  $product_subcategoriesRecord = @$product_subcategoriesRecords[0]; // get first record

  // show error message if no matching record is found
  if (!$product_subcategoriesRecord) {
    header("HTTP/1.0 404 Not Found");
    print "Record not found!";
    exit;
  }

  list($product_detailsRecords, $product_detailsMetaData) = getRecords(array(
    'tableName'   => 'product_details',
  ));

?>
<!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 $product_subcategoriesRecord['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 $product_subcategoriesRecord['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"><TABLE WIDTH="499" BORDER="0" CELLSPACING="0" CELLPADDING="0">
      <TR>
        <TD><p class="pRule"><a href="javascript:history.go(-1);">&laquo;                 Previous page</a></p>          </TD>
      </TR>
      
      
      <TR>
        <TD CLASS="tdImageFadeCell">      <!-- 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 ($product_subcategoriesRecord['main_image'] as $upload): ?>
          <?php if ($upload['hasThumbnail']): ?>
            <img src="<?php echo $upload['urlPath'] ?>" width="<?php echo $upload['width'] ?>" height="<?php echo $upload['height'] ?>" alt="" />
          <?php elseif ($upload['isImage']): ?>
            <img src="<?php echo $upload['urlPath'] ?>" width="<?php echo $upload['width'] ?>" height="<?php echo $upload['height'] ?>" alt="" />
          <?php else: ?>
          <?php endif ?>
        <?php endforeach ?>
      <!-- STEP2a: /Display Uploads --></TD>
      </TR>
      <TR>
        <TD><IMG SRC="images/single-pixel.gif" WIDTH="499" HEIGHT="10"></TD>
      </TR>
      <TR>
        <TD><P class="pNoPad"><STRONG>Light:</STRONG></P> <p><?php echo $product_subcategoriesRecord['light'] ?></p>
<P class="pNoPad"><STRONG>Plant Care: </STRONG></P><?php echo $product_subcategoriesRecord['content'] ?>
          <P class="pNoPad"><STRONG>Facts: </STRONG></P><?php echo $product_subcategoriesRecord['facts'] ?>
		      <?php if (!$product_subcategoriesRecord): ?>
    <?php endif ?></TD>
      </TR>
      <TR>
        <TD>  <!-- STEP2: Display Records (Paste this where you want your records to be listed) -->
    <ul><?php foreach ($product_detailsRecords as $record): ?>
     <li>
       <a href="<?php echo $record['_link'] ?>"><?php echo $record['title'] ?></a>
             <?php endforeach ?>
         
              <?php if (!$product_detailsRecords): ?>
       </li>
    <?php endif ?></ul>
  <!-- /STEP2: Display Records --></TD>
      </TR>
      
    </TABLE></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>
