Displaying dynamic content

Hi Nigel, 

Sorry, I didn't make that very clear. You don't need to add the $pages getRecords functions to your code, that was just an example of how the code could be implemented into a site. 

If your trying to implement this into the services.php page, then your the code that at the top of the page should probably look like this:

 <?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/content/63/10722363/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 record from 'homepage'
  list($homepageRecords, $homepageMetaData) = getRecords(array(
    'tableName'   => 'homepage',
    'where'       => '', // load first record
    'loadUploads' => true,
    'allowSearch' => false,
    'limit'       => '1',
  ));
  $homepageRecord = @$homepageRecords[0]; // get first record
  if (!$homepageRecord) { dieWith404("Record not found!"); } // show error message if no record found

  list($footer_contentRecords, $footer_contentMetaData) = getRecords(array(
    'tableName'   => 'footer-content',
    'where'       => '', // load first record
    'loadUploads' => true,
    'allowSearch' => false,
    'limit'       => '1',
  ));
  $footer_contentRecord = @$footer_contentRecords[0]; // get first record
  if (!$footer_contentRecord) { dieWith404("Record not found!"); } // show error message if no record found


  list($servicesRecords, $servicesMetaData) = getRecords(array(
    'tableName'   => 'services',
    'where'       => '', // load first record
    'loadUploads' => true,
    'allowSearch' => false,
    'limit'       => '1',
  ));
  $servicesRecord = @$servicesRecords[0]; // get first record
  if (!$servicesRecord) { dieWith404("Record not found!"); } // show error message if no record found


  // load record from 'insets-panels' uses the selected panel from the services section.
  list($insets_panelsRecords, $insets_panelsMetaData) = getRecords(array(
    'tableName'   => 'insets-panels',
    'where'       => 'num = '.$servicesRecord['name_of_list_field'],
    'loadUploads' => true,
    'allowSearch' => false,
    'limit'       => '1',
  ));
  $insets_panel = @$insets_panelsRecords[0]; // get first record
  if (!$insets_panel) { dieWith404("Record not found!"); } // show error message if no record found

?>

You will need to change the name_of_list_field variable to the name of the field that contains the list that stores the inset-panels section num variable.

I think the html to display the inset panel record should look like this:

<link href="styles.css" rel="stylesheet" type="text/css" />
        <table width="100" border="0" cellpadding="0" cellspacing="0">
          <tr>
          
  <?php foreach ($insets_panel['image'] as $index => $upload): ?>
<td width="<?php echo $upload['width'] ?>" height="<?php echo $upload['height'] ?>" valign="baseline" background="<?php echo $upload['urlPath'] ?>" id="tdHomeInset245">
<a href="<?php echo htmlencode($insets_panel['link']) ?>">
<img src="images/single-pixel.gif" width="245" height="198" border="0">
</a>
</td>
<?php endforeach ?> 
            </tr>
          <tr>
            <td><img src="images/single-pixel.gif" width="253" height="10" /></td>
          </tr>
          <tr>
            <td><h2><a href="<?php echo htmlencode($insets_panel['link']) ?>"><?php echo htmlencode($insets_panel['title']) ?></a></h2>
<?php echo $insets_panelsRecord['content']; ?>
              <p> <strong><a href="<?php echo htmlencode($insets_panel['link']) ?>">More »</a></strong></p></td>
            </tr>
      </table>

I copied this from insetDetail.php page and changed the name of the variables to use the $insets_panel instead. You can use whatever html layout you want to use. So just copy these variables where you want the inset panel to appear.

Hopefully I'm a bit clearer this time, let me know if you have any questions.

Thanks!

Greg