Help with LeftJoin

Hi mbareara,

To use the leftJoin option in getRecords in this scenario, the basic syntax generally looks like this:

list($restaurantRecords, $restaurantDetails) = getRecords(array(
  'tableName' => 'restaurants',
  'leftJoin' => array(
    'review' => 'ON restaurants.num = review.restaurant',
  ),
));

This hasn't been tested, so it may require some tweaking to work with your code, and you'll want to also add any other filtering options to getRecords that you need. The returned records should include related reviews for each restaurant record.

Let me know if you have any issues or questions!

Thanks,

Thank you Daniel

Is it the same if i use this code?

// load record from 'restaurants'
  list($restaurantsRecords, $restaurantsMetaData) = getRecords(array(
    'tableName'   => 'restaurants',
    'where'       => whereRecordNumberInUrl(0),
    'loadUploads' => true,
    'allowSearch' => false,
    'limit'       => '1',
  ));
  $localiRecord = @$restaurantsRecords[0]; // get first record


 list($reviewRecords, $reviewMetaData) = getRecords(array(
    'tableName'   => 'review',
	'where' => 'restaurant = ' . getNumberFromEndOfUrl(), 
	  'loadUploads' => false,
    'allowSearch' => false,
	 'limit'       => '1',
  ));
  $reviewRecord = @$reviewRecords[0]; // get first record

Hi mbareara,

Yes, that is generally the same thing, but with a few small differences:

• Here you're limiting the returned reviews to 1, whereas the leftJoin example would return all reviews.
• This returns two arrays of records instead of one, which can be more or less complex to handle depending on how it's being used. If it's just on a record detail page then it's likely easier.

But if your code is returning the data you want in the way you want to use it, I'd recommend sticking with it! Let me know if you have any other questions.

Thanks,