Using 'where' => to Comparing two fields of one record against another record's two fields and if both fields of each match produce results

3 posts by 2 authors in: Forums > CMS Builder
Last Post: April 15, 2014   (RSS)

By Zicky - April 14, 2014

Okay I finally got this worked out for anyone who may find this useful...

  list($our_teamRecords, $our_teamMetaData) = getRecords(array(
  'tableName'   => 'our_team',
  'where' => "first_name = '{$property_listingsRecord['first_name']}'".' AND '."last_name = '{$property_listingsRecord['last_name']}'",
  //'loadUploads' => true,
  'allowSearch' => false,
  ));

By gregThomas - April 15, 2014

Hi Zick,

Good to hear you've got working.

Let us know if there is anything else we can help with.

Cheers!

Greg

Greg Thomas

PHP Programmer - interactivetools.com