Display linked records

Hi Tim, 

Something like this should work, in this example I've used blog posts and blog categories, but the you should be able to swap it so that it uses your adverts and businesses instead. 

First you need to retrieve all of the blog categories (businesses) and sort them by num value:

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

  $blog_categories = array_groupBy($blog_categories, 'num', false);

  // load records from 'blog'
  list($blogs, $blogMeta) = getRecords(array(
    'tableName'   => 'blog',
    'loadUploads' => true,
    'allowSearch' => false,
  ));



Now when you loop through the blog records (adverts). In this example I get the appropriate blog category record (business) for each blog record from it's category (business_1,business_2,business_3) field, and set it to the blogCategory variable.


  foreach($blogs as $blog){

    //Get the appropriate blog category for blog records category field
    $blogCategory = @$blog_categories[$blog['category']];

    //Dislay an image from the associated blog category.
    if($image = @$blogCategory['image'][0] ){
      echo "<img src='{$image['urlPath']}' alt='Yes' />\r\n";
    }
  }


So with your example you would need to do something like this:


  foreach($adverts as $advert){

    //Get the appropriate businwaa records for each advert
    $business1 = @$businesses[$advert['business_1']];
    $business2 = @$businesses[$advert['business_2']];
    $business3 = @$businesses[$advert['business_3']];


    //display data here....

  }


Let me know if you have any questions.

Thanks!

Greg