I need to clarify here.

There are 2 sections that are calling for a loop

#1

foreach ($reservation_fieldsRecords as $record): 
$echo htmlencode($record['title'])=$_POST ['echo htmlencode($record['form_field'])']; 
endforeach

and #2

foreach ($reservation_fieldsRecords as $record): 
$body.='echo htmlencode($record['title']) : '.$echo htmlencode($record['form_field']) ."\n";
endforeach

in which your code seems to apply to the second loop but there is no "_post" in that one

Here is yours:

foreach ($reservation_fieldsRecords as $record){ $body .= htmlencode($record['title']) . ': ' . htmlencode($_POST[$record['form_field']]) . "\n";}

I took out the "_post" and came up with:

foreach ($reservation_fieldsRecords as $record){ $body .= htmlencode($record['title']) . ': ' . htmlencode($record['form_field']) . "\n";}

I tried to apply this logic to the first loop but my program keeps telling me its wrong. Can you format the first loop section and I will test the script?

And a couple questions I have are... 

Does the php ignore the whitespace between some characters? ...  "$body ." or " . htmlencode($record['form_field']) . "

Is your code missing something to format the lines correctly in the second loop?...  $body .' to create $body.='Departure City: '.$departure."\n";
I did not see it in there but when I added it my program said there was an error.

Thanks

Michael

I need correct code for getting the script to work with the CMS.

Thanks

Michael

I have everything working properly in the form and the fields appear properly.

But the mail script is breaking.

Original Script

<?php



$tour=$_POST['tour'];
$name=$_POST['name'];
$email=$_POST['email'];
$phone=$_POST['phone'];
$address=$_POST['address'];
$citystatezip=$_POST['citystatezip'];
$roomates=$_POST['roomates'];
$departure=$_POST['departure'];
$smoking=$_POST['smoking'];
$message=$_POST['message'];





$to='EMAIL ADDRESS';

$headers = 'From: '.$name."\r\n" .
'Reply-To: '.$email."\r\n" .
'X-Mailer: PHP/' . phpversion();
$subject ='Reservation From Rileytours.com';
$body='You have a reservation from Rileytours.com.'."\n\n";

$body.='Tour Name: '.$tour."\n";
$body.='Name: '.$name."\n";
$body.='Email: '.$email."\n";
$body.='Phone Number: '.$phone."\n";
$body.='Address: '.$address."\n";
$body.='City/State/Zip: '.$citystatezip."\n";
$body.='Roomate Name(s): '.$roomates."\n";
$body.='Departure City: '.$departure."\n";
$body.='Smoking Preference: '.$smoking."\n";
$body.='Special Request: '."\n".$message."\n";

if(mail($to, $subject, $body, $headers)) {
die("<img src=\"img/check green sm.png\" align=\"left\" hspace=\"5px\" /><strong>Thanks. Your reservation has been sent and someone will contact you with a confirmation shortly. <br/>
    If you need immediate assistance please contact us at the phone numbers below.</strong>"); 
} else {
die('Oops! Your email failed for some reason. Please try it again and see if it will go through.<br/>
If it does not work again please contact us directly.');
}

?>

This is what I have but I know that I have the code from the CMS assembled wrong

<?php
 
  $libraryPath = 'cmsAdmin/lib/viewer_functions.php';
  $dirsToCheck = array('D:/HostingSpaces/rileytours/rileytours.com/wwwroot/','','../','../../','../../../');
  foreach ($dirsToCheck as $dir) { if (@include_once("$dir$libraryPath")) { break; }}
  if (!function_exists('getRecords')) { die("Couldn't load viewer library, check filepath in sourcecode."); }

  list($reservation_fieldsRecords, $reservation_fieldsMetaData) = getRecords(array(
    'tableName'   => 'reservation_fields',
    'loadUploads' => false,
    'allowSearch' => false,
  ));
  
$email=$_POST['email'];
foreach ($reservation_fieldsRecords as $record): 
$echo htmlencode($record['title'])=$_POST ['echo htmlencode($record['form_field'])']; 
endforeach
$departure=$_POST['departure'];
$smoking=$_POST['smoking'];
$message=$_POST['message'];




$to='EMAIL ADDRESS';

$headers = 'From: '.$fullname1."\r\n" .
'Reply-To: '.$email."\r\n" .
'X-Mailer: PHP/' . phpversion();
$subject ='Reservation From Rileytours.com';
$body='You have a reservation from Rileytours.com.'."\n\n";


$body.='Email: '.$email."\n";
foreach ($reservation_fieldsRecords as $record): 
$body.='echo htmlencode($record['title']): '.$echo htmlencode($record['form_field']) ."\n";
endforeach
$body.='Departure City: '.$departure."\n";
$body.='Smoking Preference: '.$smoking."\n";
$body.='Special Request: '."\n".$message."\n";



if(mail($to, $subject, $body, $headers)) {
die("<img src=\"img/check green sm.png\" align=\"left\" hspace=\"5px\" /><strong>Thanks. Your reservation has been sent and someone will contact you with a confirmation shortly. <br/>
    If you need immediate assistance please contact us at the phone numbers below.</strong>"); 
} else {
die('Oops! Your email failed for some reason. Please try it again and see if it will go through.<br/>
If it does not work again please contact us directly.');
}

?>

How should these lines be written?

Thanks for your help

Michael

Thanks
Michael

Any ideas?

Michael

One step closer.

We got rid of the errors but it seems to skip over your code altogether.

Here is what I have: (the main chunks LOL)

  // load records from 'resource_links_docs'
  list($resource_links_docsRecords, $resource_links_docsMetaData) = getRecords(array(
    'tableName'   => 'resource_links_docs',
    'loadUploads' => true,
    'allowSearch' => false,
  ));
  
  $records = array_groupBy($resource_links_docsRecords, 'category:label');



    <h1>Leo's Code</h1>
   <? foreach($records as $categoryLabel => $recordsByCategory): // HTML for the category label?>
    <h4><p><?php echo ($categoryLabel) ?></p></h4>
   <? foreach($recordsByCategory as $record): ?>
    <ul>
<li><?php echo ($record['title']) // HTML for each record ?></li>
    </ul>
   <? endforeach ?>
   <hr/>
   <? endforeach ?>

    <h1>Regular Viewer Code</h1>
    <?php foreach ($resource_links_docsRecords as $record): ?>
    
      Record Number: <?php echo htmlencode($record['num']) ?><br/>
      Title: <?php echo htmlencode($record['title']) ?><br/>
      Category (values): <?php echo join(', ', $record['category:values']); ?><br/>
      Category (labels): <?php echo join(', ', $record['category:labels']); ?><br/>
      Link: <?php echo htmlencode($record['link']) ?><br/>

      <hr/>
    <?php endforeach ?>

    <?php if (!$resource_links_docsRecords): ?>
      No records were found!<br/><br/>
    <?php endif ?>


You can see the result here:

http://homevaluerealestate.biz/resourcesTEST.php

Thanks 

Michael

I changed it to $categoryLabel which now it is showing the category "number" but not the actual title of the category.

Both the category list and the docs/links list have a "title"

And the docs/links section does have a "category" field as it is a list pulling the of "category" list into it. (see attached image)

So I am seeing where you're going but something is still missing.

What do you think?

Michael

I have broken out what you did so that I can have more control over how I display it

But I'm getting errors and I am hoping it's because of how I am adding the strings.

   <? foreach($records as $categoryLabel => $recordsByCategory): // HTML for the category label?>
    <h4><p><?php echo ($categoryLabel['lables']) ?></p></h4>
   <? foreach($recordsByCategory as $record): ?>
    <ul>
<li><?php echo ($record['title']) // HTML for each record ?></li>
    </ul>
   <? endforeach ?>
   <hr/>
   <? endforeach ?>

The errors I'm getting back are:

Warning: Illegal string offset 'lables' in /home/homevaluere/public_html/resourcesTEST.php on line 34

• Warning: Illegal string offset 'title' in /home/homevaluere/public_html/resourcesTEST.php on line 37 R
• Notice: Undefined index: title in /home/homevaluere/public_html/resourcesTEST.php on line 37
• Notice: Undefined index: title in /home/homevaluere/public_html/resourcesTEST.php on line 37
• AND SO ON .....

I am closer than I was  ...

What is the problem? (Page attached)

Michael

I am not experienced enough to see that work out in code.

Thanks
Your help is greatly appreciated.

Michael

So my loading code looks like this:

  // load records from 'resource_links_docs'
  list($resource_links_docsRecords, $resource_links_docsMetaData) = getRecords(array(
    'tableName'   => 'resource_links_docs',
    'loadUploads' => true,
    'allowSearch' => false,
  ));

So I want to layout the doc/link lists by category:

First Category
Doc
Link
Link
Doc
Etc...

Second Category
Doc
Doc
Link
Doc
Etc...

And So on

So I have these variables:

<?php echo htmlencode($record['title']) ?>
      <?php echo join(', ', $record['category:values']); ?>
      <?php echo join(', ', $record['category:labels']); ?>
      <?php echo htmlencode($record['link']) ?>
       <?php foreach ($record['document'] as $index => $upload): ?>
        <?php echo htmlencode($upload['urlPath']) ?>
       <?php endforeach ?>


And would like to set it up like this:

<foreach...>
<h4><category:labels></h4>
 <if upload then...> 
   <?php foreach ($record['document'] as $index => $upload): ?>
     <a href="<?php echo htmlencode($upload['urlPath']) ?>"><p><?php echo htmlencode($upload['filename']) ?></p></a>
   <?php endforeach ?>    
 <else>
  <a href="<?php echo htmlencode($record['link']) ?>" target="_blank"><p><?php echo htmlencode($record['title']) ?></p></a>
<?php endforeach ?>


So I know this has been done by me before but I can not remember and can not seem to find the correct example to work off of.

Thanks for your help with this.

Michael

The link to the page sorts the list by a particular "type"

....resource_list.php?type=5 

Then I have the type list called and the documents themselves called

  list($resource_documentsRecords, $resource_documentsMetaData) = getRecords(array(
    'tableName'   => 'resource_documents',
    'loadUploads' => false,
    'where'       => 'resource_type = '.mysql_escape(@$_REQUEST['type']),
    'allowSearch' => true,
  ));
  
    list($resource_documentstypeRecords, $resource_documentsMetaData) = getRecords(array(
    'tableName'   => 'resource_documents',
    'where'       => 'resource_type = '.mysql_escape(@$_REQUEST['type']),
    'loadUploads' => true,
    'allowSearch' => false,
    'limit'       => '1',
  ));

  $resource_documentsRecord = @$resource_documentstypeRecords[0]; // get first record
  if (!$resource_documentsRecord) { dieWith404("Record type not found!"); } // show error message if no record found

My section is looping the document names and inserting the upload link for each document

The loop works to show the names of the documents

But something is breaking the page in the loop when I inject the upload code

<?php foreach ($resource_documentsRecords as $record): ?>
 <?php $uploads = getUploads($options['resource_documents'], 'uploads', $record['num']); ?>
       <ul class="h3">
           <li><?php foreach ($uploads as $upload): ?><a href="<?php echo $uploads['urlPath'] ?>" target="_blank"><?php endforeach ?><?php echo htmlencode($record['title']) ?></a></li>
       </ul>  
<?php endforeach ?>

My upload is called 'resource_upload' but I am unable to figure out where that goes into the mix

Thanks for your help 

Michael

I know I'm close but. ..

Thanks

Michael

The client has added another filter to the mix. They have asked that there be just a list of "agricultural" or "recreational" dealers.

I created a new separate list "dealer_types"(multiple check boxes) and associated it in the dealers section using the field name "type".

What I BELIEVE I need is a "if" {  continue;  } statement to filter only 1 type of dealer by the record number. Or an "if" "else" statement maybe..

                            <?php foreach ($canadian_statesRecords as $key=>$record): ?>
                                       <? // load records from 'dealers'
                                         list($dealersRecords, $dealersMetaData) = getRecords(array(
                                         'tableName'   => 'dealers',
                                         'loadUploads' => false,
                                         'allowSearch' => false,
                                         'where' => "providences LIKE '%\t". mysql_escape($record['num']) . "\t%'",
                                          ));
                                        ?>
                            <?php if(empty($dealersRecords)) { continue; } ?>
                                <section class="toggle<?php if ($key == 0) { echo " active"; } ?>">
                                    <label><?php echo htmlencode($record['title']) ?></label>
                                    <div class="toggle-content">
                                    <?php foreach ($dealersRecords as $dealer): ?>
                                    <?php IF DEALER "TYPE" NUM = ANYTHING BUT "1" { continue; } ?> //  I will assign which record number I want to filter
                                    <div class="panel-body">
                                      <strong><?php echo htmlencode($dealer['title']) ?></strong><br/>
                                             <p>
                                              <?php echo htmlencode($dealer['address']) ?><br/>
                                              <?php echo htmlencode($dealer['phone']) ?><br/>
                                              Contact: <?php echo htmlencode($dealer['contact_name']) ?>
                                             </p>
                                         <hr>
                                     </div>
                                     <?php endforeach ?>
                                    </div>
                                </section>
                            <?php endforeach ?>

Let me know what you think,

Thanks
Michael

http://tebben.us.r16.millsys.org/product.php?Tandem-Axle-Hydraulic-Lift-30

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

-------------------------------------------------------------------------------

                             <ul class="portfolio-details">
                                <li>
                                    <p><strong>Features:</strong></p>
                                    <ul class="list list-skills icons list-unstyled list-inline">
                                    <?php foreach ($productsRecord as $record): ?>
                                    <?php $lines = explode("\n", $productsRecord['product_features']); ?>
                                    <?php foreach ($lines as $line) : ?>
                                     <?php if($line != ''): ?>
                                 
                                        <li><i class="fa fa-check-circle"></i><?php echo $line; ?></li>
                                        
                                    
                                    <?php endif; ?>
                                    <?php endforeach; ?>
                                    <?php endforeach ?>
                                    </ul>
                                </li>
                            </ul>


Let me know what you think.

Thanks

Michael

Works awesome!

So there is the loop of States with a loop of distributors inside of it and then there will also be a loop of Providences with a loop of distributors right afterward. So you are only seeing the code for the first loop.

I was hoping to replicate the solution for the Providences once I had that. Just needed to get it working properly. 

Hope that helps 
Thanks

Any ideas?

  list($statesRecords, $statesMetaData) = getRecords(array(
    'tableName'   => 'states',
    'loadUploads' => false,
    'allowSearch' => false,
  ));


-------------------------------------------------------------




<?php foreach ($statesRecords as $key=>$record): ?>
  <div class="panel-group secundary" id="accordion2">
    <div class="panel panel-default">
      <div class="panel-heading">
       <h4 class="panel-title">
        <a class="accordion-toggle" data-toggle="collapse" data-parent="#accordion2" href="#collapse2<?php echo $key;?>"><?php echo htmlencode($record['title']) ?></a>
       </h4>
      </div>
      <div id="collapse2<?php echo $key;?>" class="accordion-body collapse">
          <? // load records from 'distributors'
          list($distributorsRecords, $distributorsMetaData) = getRecords(array(
            'tableName'   => 'distributors',
            'loadUploads' => false,
            'allowSearch' => false,
            'where' => "states = '". $record['num'] . "'",
             ));
           ?>
          <?php foreach ($distributorsRecords as $distributor): ?>
            <div class="panel-body">
              <strong><?php echo htmlencode($distributor['title']) ?></strong><br/>
              <p><?php echo htmlencode($distributor['address']) ?><br/>
                 <?php echo htmlencode($distributor['phone']) ?><br/>
                 Contact: <?php echo htmlencode($distributor['contact_name']) ?>
              </p>
                                         <hr>
             </div>
          <?php endforeach ?>
                                   
        </div>
    </div>
  </div>
<?php endforeach ?>

Can I write it somehow to list ONLY the states that actually have a distributor. Please Note: I built this as a list of states that are associated in a list of distributors. Maybe I need to move that get records to the outside of the loop?

Let me know what you think.

<h1 class="short word-rotator-title">
TEBBEN is a quality manufacturer of <strong class="inverted">
<span class="word-rotate" data-plugin-options='{"delay": 2000, "animDelay": 300}'>
<span class="word-rotate-items">
  <span>Quality Farm Equipment</span>
  <span>Industrial Equipment</span>
  <span>Boat Trailers</span>
</span>
</span>
</strong>
</h1>

<h1 class="short word-rotator-title">
TEBBEN is a quality manufacturer of <strong class="inverted">
<span class="word-rotate" data-plugin-options='{"delay": 2000, "animDelay": 300}'>
<span class="word-rotate-items">
   <?php foreach ($homepageRecord as $record): ?>
   <span><?php echo htmlencode($homepageRecord['rotating_upper_words']) ?></span> // This need to be fixed to echo each line item in the text box
   <?php endforeach ?>
</span>
</span>
</strong>
</h1>

Please advise

Michael

Inserted your Show me code:

      <?php foreach ($resource_typeRecords as $record): ?>
        <div class='col-md-3 service'>
          <h3>
            <span class='fa fa-<?php echo htmlencode($record['resource_type_icon']) ?>'></span>
            <?php echo htmlencode($record['title']) ?>
          </h3>
          <p class='small'><?php echo strip_tags($record['content']); ?></p>
          <?php showme($type); ?>
          <a class='btn btn-default btn-md' href="categorytype.php?type=<?php echo $type['num'];?>">
            <span class='fa fa-caret-right'></span>
             Read more
          </a>
        </div>
      <?php endforeach ?>

and I get this in the returned source code:

Sorry for the lengthy code here but this is one trip through the above loop.

  <div class='col-md-3 service'>    
   <h3>
            <span class='fa fa-search'></span>
            Case Study          </h3>
          <p class='small'>Learn first-hand how we help our clients drive important business results.</p>
          <xmp>Array
(
    [0] => Array
        (
            [num] => 1
            [createdDate] => 2014-09-22 01:12:33
            [createdByUserNum] => 1
            [updatedDate] => 2014-09-27 07:11:35
            [updatedByUserNum] => 1
            [dragSortOrder] => 70
            [title] => Case Study
            [content] => <p>Learn first-hand how we help our clients drive important business results.</p>
            [resource_type_icon] => search
            [_tableName] => resource_type
        )

    [1] => Array
        (
            [num] => 2
            [createdDate] => 2014-09-22 01:12:59
            [createdByUserNum] => 1
            [updatedDate] => 2014-09-27 07:15:00
            [updatedByUserNum] => 1
            [dragSortOrder] => 10
            [title] => Sample Product Report
            [content] => <p>The essence of relationships, especially High Performance Teams, is communication. It is through communication that people share information, make decisions, solve problems and accomplish their day-to-day jobs.</p>
            [resource_type_icon] => file-text-o
            [_tableName] => resource_type
        )

    [2] => Array
        (
            [num] => 5
            [createdDate] => 2014-09-22 01:15:24
            [createdByUserNum] => 1
            [updatedDate] => 2014-09-27 07:13:13
            [updatedByUserNum] => 1
            [dragSortOrder] => 40
            [title] => Form
            [content] => <p>A collection of forms to help you analyze and strategize different aspects of your business. Download and use them as they apply to your situation.</p>
            [resource_type_icon] => list-ol
            [_tableName] => resource_type
        )

    [3] => Array
        (
            [num] => 6
            [createdDate] => 2014-09-22 01:15:58
            [createdByUserNum] => 1
            [updatedDate] => 2014-09-27 07:12:35
            [updatedByUserNum] => 1
            [dragSortOrder] => 50
            [title] => Newsletter
            [content] => <p>Our archive of newsletters with important topics about business practices and articals that make a difference to managers and employees.</p>
            [resource_type_icon] => newspaper-o
            [_tableName] => resource_type
        )

    [4] => Array
        (
            [num] => 7
            [createdDate] => 2014-09-22 01:16:44
            [createdByUserNum] => 1
            [updatedDate] => 2014-09-27 07:11:56
            [updatedByUserNum] => 1
            [dragSortOrder] => 60
            [title] => White Paper
            [content] => <p>See our collected studies of real life stratagies used by our clients and other successful businesses.</p>
            [resource_type_icon] => file-o
            [_tableName] => resource_type
        )

)
</xmp>          <a class='btn btn-default btn-md' href="categorytype.php?type=
Notice: Undefined index: num in /data/13/0/142/86/142086/user/143888/htdocs/newsite/pages/resources.php on line 151
">
            <span class='fa fa-caret-right'></span>
             Read more
          </a>
        </div>
              <div class='col-md-3 service'>
          <h3>
            <span class='fa fa-file-o'></span>
            White Paper          </h3>
          <p class='small'>See our collected studies of real life stratagies used by our clients and other successful businesses.</p>
          <xmp>Array
(
    [0] => Array
        (
            [num] => 1
            [createdDate] => 2014-09-22 01:12:33
            [createdByUserNum] => 1
            [updatedDate] => 2014-09-27 07:11:35
            [updatedByUserNum] => 1
            [dragSortOrder] => 70
            [title] => Case Study
            [content] => <p>Learn first-hand how we help our clients drive important business results.</p>
            [resource_type_icon] => search
            [_tableName] => resource_type
        )

    [1] => Array
        (
            [num] => 2
            [createdDate] => 2014-09-22 01:12:59
            [createdByUserNum] => 1
            [updatedDate] => 2014-09-27 07:15:00
            [updatedByUserNum] => 1
            [dragSortOrder] => 10
            [title] => Sample Product Report
            [content] => <p>The essence of relationships, especially High Performance Teams, is communication. It is through communication that people share information, make decisions, solve problems and accomplish their day-to-day jobs.</p>
            [resource_type_icon] => file-text-o
            [_tableName] => resource_type
        )

    [2] => Array
        (
            [num] => 5
            [createdDate] => 2014-09-22 01:15:24
            [createdByUserNum] => 1
            [updatedDate] => 2014-09-27 07:13:13
            [updatedByUserNum] => 1
            [dragSortOrder] => 40
            [title] => Form
            [content] => <p>A collection of forms to help you analyze and strategize different aspects of your business. Download and use them as they apply to your situation.</p>
            [resource_type_icon] => list-ol
            [_tableName] => resource_type
        )

    [3] => Array
        (
            [num] => 6
            [createdDate] => 2014-09-22 01:15:58
            [createdByUserNum] => 1
            [updatedDate] => 2014-09-27 07:12:35
            [updatedByUserNum] => 1
            [dragSortOrder] => 50
            [title] => Newsletter
            [content] => <p>Our archive of newsletters with important topics about business practices and articals that make a difference to managers and employees.</p>
            [resource_type_icon] => newspaper-o
            [_tableName] => resource_type
        )

    [4] => Array
        (
            [num] => 7
            [createdDate] => 2014-09-22 01:16:44
            [createdByUserNum] => 1
            [updatedDate] => 2014-09-27 07:11:56
            [updatedByUserNum] => 1
            [dragSortOrder] => 60
            [title] => White Paper
            [content] => <p>See our collected studies of real life stratagies used by our clients and other successful businesses.</p>
            [resource_type_icon] => file-o
            [_tableName] => resource_type
        )

)
</xmp>          <a class='btn btn-default btn-md' href="categorytype.php?type=
Notice: Undefined index: num in /data/13/0/142/86/142086/user/143888/htdocs/newsite/pages/resources.php on line 151
">
            <span class='fa fa-caret-right'></span>
             Read more
          </a>
        </div>
              <div class='col-md-3 service'>
          <h3>
            <span class='fa fa-newspaper-o'></span>
            Newsletter          </h3>
          <p class='small'>Our archive of newsletters with important topics about business practices and articals that make a difference to managers and employees.</p>
          <xmp>Array
(
    [0] => Array
        (
            [num] => 1
            [createdDate] => 2014-09-22 01:12:33
            [createdByUserNum] => 1
            [updatedDate] => 2014-09-27 07:11:35
            [updatedByUserNum] => 1
            [dragSortOrder] => 70
            [title] => Case Study
            [content] => <p>Learn first-hand how we help our clients drive important business results.</p>
            [resource_type_icon] => search
            [_tableName] => resource_type
        )

    [1] => Array
        (
            [num] => 2
            [createdDate] => 2014-09-22 01:12:59
            [createdByUserNum] => 1
            [updatedDate] => 2014-09-27 07:15:00
            [updatedByUserNum] => 1
            [dragSortOrder] => 10
            [title] => Sample Product Report
            [content] => <p>The essence of relationships, especially High Performance Teams, is communication. It is through communication that people share information, make decisions, solve problems and accomplish their day-to-day jobs.</p>
            [resource_type_icon] => file-text-o
            [_tableName] => resource_type
        )

    [2] => Array
        (
            [num] => 5
            [createdDate] => 2014-09-22 01:15:24
            [createdByUserNum] => 1
            [updatedDate] => 2014-09-27 07:13:13
            [updatedByUserNum] => 1
            [dragSortOrder] => 40
            [title] => Form
            [content] => <p>A collection of forms to help you analyze and strategize different aspects of your business. Download and use them as they apply to your situation.</p>
            [resource_type_icon] => list-ol
            [_tableName] => resource_type
        )

    [3] => Array
        (
            [num] => 6
            [createdDate] => 2014-09-22 01:15:58
            [createdByUserNum] => 1
            [updatedDate] => 2014-09-27 07:12:35
            [updatedByUserNum] => 1
            [dragSortOrder] => 50
            [title] => Newsletter
            [content] => <p>Our archive of newsletters with important topics about business practices and articals that make a difference to managers and employees.</p>
            [resource_type_icon] => newspaper-o
            [_tableName] => resource_type
        )

    [4] => Array
        (
            [num] => 7
            [createdDate] => 2014-09-22 01:16:44
            [createdByUserNum] => 1
            [updatedDate] => 2014-09-27 07:11:56
            [updatedByUserNum] => 1
            [dragSortOrder] => 60
            [title] => White Paper
            [content] => <p>See our collected studies of real life stratagies used by our clients and other successful businesses.</p>
            [resource_type_icon] => file-o
            [_tableName] => resource_type
        )

)
</xmp>          <a class='btn btn-default btn-md' href="categorytype.php?type=
Notice: Undefined index: num in /data/13/0/142/86/142086/user/143888/htdocs/newsite/pages/resources.php on line 151
">
            <span class='fa fa-caret-right'></span>
             Read more
          </a>
        </div>
              <div class='col-md-3 service'>
          <h3>
            <span class='fa fa-list-ol'></span>
            Form          </h3>
          <p class='small'>A collection of forms to help you analyze and strategize different aspects of your business. Download and use them as they apply to your situation.</p>
          <xmp>Array
(
    [0] => Array
        (
            [num] => 1
            [createdDate] => 2014-09-22 01:12:33
            [createdByUserNum] => 1
            [updatedDate] => 2014-09-27 07:11:35
            [updatedByUserNum] => 1
            [dragSortOrder] => 70
            [title] => Case Study
            [content] => <p>Learn first-hand how we help our clients drive important business results.</p>
            [resource_type_icon] => search
            [_tableName] => resource_type
        )

    [1] => Array
        (
            [num] => 2
            [createdDate] => 2014-09-22 01:12:59
            [createdByUserNum] => 1
            [updatedDate] => 2014-09-27 07:15:00
            [updatedByUserNum] => 1
            [dragSortOrder] => 10
            [title] => Sample Product Report
            [content] => <p>The essence of relationships, especially High Performance Teams, is communication. It is through communication that people share information, make decisions, solve problems and accomplish their day-to-day jobs.</p>
            [resource_type_icon] => file-text-o
            [_tableName] => resource_type
        )

    [2] => Array
        (
            [num] => 5
            [createdDate] => 2014-09-22 01:15:24
            [createdByUserNum] => 1
            [updatedDate] => 2014-09-27 07:13:13
            [updatedByUserNum] => 1
            [dragSortOrder] => 40
            [title] => Form
            [content] => <p>A collection of forms to help you analyze and strategize different aspects of your business. Download and use them as they apply to your situation.</p>
            [resource_type_icon] => list-ol
            [_tableName] => resource_type
        )

    [3] => Array
        (
            [num] => 6
            [createdDate] => 2014-09-22 01:15:58
            [createdByUserNum] => 1
            [updatedDate] => 2014-09-27 07:12:35
            [updatedByUserNum] => 1
            [dragSortOrder] => 50
            [title] => Newsletter
            [content] => <p>Our archive of newsletters with important topics about business practices and articals that make a difference to managers and employees.</p>
            [resource_type_icon] => newspaper-o
            [_tableName] => resource_type
        )

    [4] => Array
        (
            [num] => 7
            [createdDate] => 2014-09-22 01:16:44
            [createdByUserNum] => 1
            [updatedDate] => 2014-09-27 07:11:56
            [updatedByUserNum] => 1
            [dragSortOrder] => 60
            [title] => White Paper
            [content] => <p>See our collected studies of real life stratagies used by our clients and other successful businesses.</p>
            [resource_type_icon] => file-o
            [_tableName] => resource_type
        )

)
</xmp>          <a class='btn btn-default btn-md' href="categorytype.php?type=
Notice: Undefined index: num in /data/13/0/142/86/142086/user/143888/htdocs/newsite/pages/resources.php on line 151
">
            <span class='fa fa-caret-right'></span>
             Read more
          </a>
        </div>
              <div class='col-md-3 service'>
          <h3>
            <span class='fa fa-file-text-o'></span>
            Sample Product Report          </h3>
          <p class='small'>The essence of relationships, especially High Performance Teams, is communication. It is through communication that people share information, make decisions, solve problems and accomplish their day-to-day jobs.</p>
          <xmp>Array
(
    [0] => Array
        (
            [num] => 1
            [createdDate] => 2014-09-22 01:12:33
            [createdByUserNum] => 1
            [updatedDate] => 2014-09-27 07:11:35
            [updatedByUserNum] => 1
            [dragSortOrder] => 70
            [title] => Case Study
            [content] => <p>Learn first-hand how we help our clients drive important business results.</p>
            [resource_type_icon] => search
            [_tableName] => resource_type
        )

    [1] => Array
        (
            [num] => 2
            [createdDate] => 2014-09-22 01:12:59
            [createdByUserNum] => 1
            [updatedDate] => 2014-09-27 07:15:00
            [updatedByUserNum] => 1
            [dragSortOrder] => 10
            [title] => Sample Product Report
            [content] => <p>The essence of relationships, especially High Performance Teams, is communication. It is through communication that people share information, make decisions, solve problems and accomplish their day-to-day jobs.</p>
            [resource_type_icon] => file-text-o
            [_tableName] => resource_type
        )

    [2] => Array
        (
            [num] => 5
            [createdDate] => 2014-09-22 01:15:24
            [createdByUserNum] => 1
            [updatedDate] => 2014-09-27 07:13:13
            [updatedByUserNum] => 1
            [dragSortOrder] => 40
            [title] => Form
            [content] => <p>A collection of forms to help you analyze and strategize different aspects of your business. Download and use them as they apply to your situation.</p>
            [resource_type_icon] => list-ol
            [_tableName] => resource_type
        )

    [3] => Array
        (
            [num] => 6
            [createdDate] => 2014-09-22 01:15:58
            [createdByUserNum] => 1
            [updatedDate] => 2014-09-27 07:12:35
            [updatedByUserNum] => 1
            [dragSortOrder] => 50
            [title] => Newsletter
            [content] => <p>Our archive of newsletters with important topics about business practices and articals that make a difference to managers and employees.</p>
            [resource_type_icon] => newspaper-o
            [_tableName] => resource_type
        )

    [4] => Array
        (
            [num] => 7
            [createdDate] => 2014-09-22 01:16:44
            [createdByUserNum] => 1
            [updatedDate] => 2014-09-27 07:11:56
            [updatedByUserNum] => 1
            [dragSortOrder] => 60
            [title] => White Paper
            [content] => <p>See our collected studies of real life stratagies used by our clients and other successful businesses.</p>
            [resource_type_icon] => file-o
            [_tableName] => resource_type
        )

)
</xmp>          <a class='btn btn-default btn-md' href="categorytype.php?type=
Notice: Undefined index: num in /data/13/0/142/86/142086/user/143888/htdocs/newsite/pages/resources.php on line 151
">
            <span class='fa fa-caret-right'></span>
             Read more
          </a>
        </div>


It seems to be repeating all the records for each trip through the loop.

I sure hope this gives you an idea on whats going on.

Header:

  list($resources_pageRecords, $resources_pageMetaData) = getRecords(array(
    'tableName'   => 'resources_page',
    'where'       => '', // load first record
    'loadUploads' => true,
    'allowSearch' => false,
    'limit'       => '1',
  ));
  $resources_pageRecord = @$resources_pageRecords[0]; // get first record
  if (!$resources_pageRecord) { dieWith404("Record not found!"); } // show error message if no record found
  
    list($resource_typeRecords, $resource_typeMetaData) = getRecords(array(
    'tableName'   => 'resource_type',
    'loadUploads' => false,
    'allowSearch' => false,
  ));
  $type = mysql_select ('resource_type');


In the page I put:

<?php foreach ($resource_typeRecords as $record): ?>
        <div class='col-md-3 service'>
          <h3>
            <span class='fa fa-<?php echo htmlencode($record['resource_type_icon']) ?>'></span>
            <?php echo htmlencode($record['title']) ?>
          </h3>
          <p class='small'><?php echo $record['content']; ?></p>
          <a class='btn btn-default btn-md' href="categorytype.php?type=<?php echo $type['num'];?>">
            <span class='fa fa-caret-right'></span>
             Read more
          </a>
        </div>
      <?php endforeach ?>

On the page when I rollover the link I can see the link itself has an error saying:

categorytype.php?type=Notice:%20Undefined%20index:%20num%20in%20/data/13/0/142/86/142086/user/143888/htdocs/newsite/pages/resources.php%20on%20line%20109

What could be causing it not to grab the "num"?

Thanks

My next question would be how to come from a category page to a specific type list page

If I make a foreach loop to create a list of documents by types.

So I would start on the category page (lets say "resources.php") with:

  list($resource_typeRecords, $resource_typeMetaData) = getRecords(array(
    'tableName'   => 'resource_type',
    'loadUploads' => false,
    'allowSearch' => false,
  ));
$type = mysql_select ('resource_type');


And then show the categories in columns: 

  <section class='white trans' id='content'>
    <?php foreach ($resource_typeRecords as $record): ?>
      <div class='col-md-12 col-md-offset-0'>
        <div class='col-md-3 service'>
          <h3>
            <span class='fa fa-search'></span>
            <?php echo htmlencode($record['title']) ?>
          </h3>
          <p class='small'><?php echo $record['content']; ?></p>
          <a class='btn btn-default btn-md'>
            <span class='fa fa-caret-right'></span>
            <a href="categorytype.php?type=<?php echo $type['title'];?>">Read more</a>
          </a>
        </div>
      </div>
   <?php endforeach ?>
  </section>

SOOO

If I want the link to be built to go to a single category list page (I suppose I would NOT set that up in the "viewer links tab" ) using the "title" in the link (example categorytype.php?type=)

And then what the code look like on the receiving list page (categorytype.php) to understand that we are looking for a list of resources based on the type in the link

I am only guessing  on this

  list($resource_documentsRecords, $resource_documentsMetaData) = getRecords(array(
    'tableName'   => 'resource_documents',
    'loadUploads' => false,
    'allowSearch' => true,
  ));

I think I am close on some but not everything.

Thanks for your help

I need to make a list of each depending on the type of document it is.

So here is the list of types (lable = title)

Case Study 
White Paper
Newsletter
Form
Webinar
Recorded Webinar
Sample Product Report

So if I need a list of documents that are just Case Studies or whatever.... what would that look like?

<?php foreach ($resource_documentsRecords as $record): ?>

if resource_type:label = Case Study 

<?php endforeach ?>


Im not sure if it needs an if statement or if that can be worked out inside the foreach statement

Thanks in advance

And just an FYI this will lead into a similar followup question.