info from two tables on one page

Hi Daniel,

The search filter works if I use the title field, however to expand a little.

I am using two tables to provide information on the list page and I wanted both tables to be filtered on the same field ie "category"

so

table 1 = "information_pages" contains lots of records that each have a category field to allow me to filter and list records with the same category value ie all records relating to Beaches

table 2 - "information_section_headers" which contains  a number of records (1 for each category value) containg title and description text relevant to that category.

both those tables use a third table "categories_list" to provide a drop down selection for the category value. ie Beaches, Harbour, shopping etc

I have done this to ensure that any new categories created are automatically available when creating records in tables 1 & 2

What I am looking to achieve is to create a menu link such as "information-pages.php?category=Beaches" and have the page display the listings of all records where the category value matches Beaches in table 1 and also provide the title and description text from table 2 from the record which has the category value Beaches.

For whatever reason the records from table 1 "information_pages" display correctly but I cannot get any content from table 2 to display on the page.  I am sure it is something simple that I am doing wrong or missing due to my lack of knowledge in php and sql so any help provided in the simplest form so even I can understand would be very much appreciated.

At the moment my head code is

 list($information_section_headersRecords, $information_section_headersMetaData) = getRecords(array(
    'tableName'   => 'information_section_headers',
    'where'       => '',
    'loadUploads' => false,
    'allowSearch' => true,
    'limit'       => '1',
  ));
  


  // load records from 'information_pages'
  list($information_pagesRecords, $information_pagesMetaData) = getRecords(array(
    'tableName'   => 'information_pages',
    'orderBy'     => 'RAND()',
    'loadUploads' => true,
    'allowSearch' => true,
  ));

and my display code is

                    <?php foreach ($information_section_headersRecords as $record): ?>
    title here <?php echo htmlencode($record['title']) ?><br/>
      
     content here <?php echo $record['content']; ?><br/>
		
      <?php endforeach ?>  




          <?php foreach ($information_pagesRecords as $record): ?>
            <li>
            <?php foreach ($record['uploads'] as $index => $upload): ?>
          <?php if ($index >= 1) { continue; } // limit uploads shown ?>
            
             
                <a data-description="data-description" data-largesrc="<?php echo htmlencode($upload['thumbUrlPath2']) ?>" data-title="<?php echo htmlencode($record['title']) ?>" href="#">
                    <img alt="<?php echo htmlencode($record['title']) ?>" src="<?php echo htmlencode($upload['thumbUrlPath2']) ?>" />
                </a>
                <?php endforeach ?>
                <h3>
                    <?php echo htmlencode($record['title']) ?> <br>
					<?php echo htmlencode($record['telephone']) ?>
                </h3>  
                <div class="gallery1-content">
                    <div>
                        <h3>
                           <?php echo htmlencode($record['title']) ?>
                        </h3>
                      
                        <p>
                            <?PHP echo maxWords($record['content'],50) ?> <br>
							<?php echo htmlencode($record['telephone']) ?><br>
							<?php echo htmlencode($record['contact_email']) ?>
                        </p>
                        <a href="<?php echo $record['_link'] ?>"class="btn btn-primary">Read More..</a>
                            
                            
                            
                        <p></p>
                    </div>
                </div>
            </li>
            <?php endforeach ?>