MultiSearch.php

Hi Tim,

Here is some code that will take the user to a detail page if there is content or else if not content, send them to an alternate link:

<?php if ($record['_summary']): ?>
  <a href="<?php echo $record['_link'] ?>" style="color: #008000"><?php echo $record['_link'] ?></a><br/><br/>
<?php else : ?>
  <a href="alternate_link.php" style="color: #008000">ALTERNATE LINK</a><br/><br/>
<?php endif ?>

Also, inside the foreach loop for the search results, you can add this code to see all the data and variable names you are working with:

<?php showme($record); ?>

This helps with setup and testing. Let me know if you have any questions or need anything else.

Thanks Damon,

However this will not work for me because every table is different, and therefore has a different alternate link.

I think I need something that will allow me to prescribe the various URL's for each table - or maybe use the Viewer URL's set up in the section editor? Something along the lines of this?

$searchTables['table1'] = array(
'viewerUrl' => 'detailPage1.php',
'titleField' => 'name',
'summaryField' => 'masthead',
'searchFields' => array('name','masthead','page_content','content'),
'detailPage' => 'permalink', //This is the permalink field
'indexPage' => 'indexPage1.php',
'checkfordetail' => 'content',

);
$searchTables['table2'] = array(
'viewerUrl' => 'detailPage2.php',
'titleField' => 'title',
'summaryField' => 'content',
'searchFields' => array('title','content','details'),
'detailPage' => 'detailPage2.php',
'indexPage' => 'indexPage2.php',
'checkfordetail' => 'details',

);

);
$searchTables['table3'] = array(
'viewerUrl' => 'detailPage3.php',
'titleField' => 'title',
'summaryField' => 'content',
'searchFields' => array('title','content','details'),
'detailPage' => 'detailPage3.php',
'indexPage' => 'indexPage3.php',
'checkfordetail' => 'details',

);

<?php if ($record['checkfordetail']): ?>
  <a href="<?php echo $record['detailPage'] ?>" style="color: #008000">DETAIL PAGE LINK IF THERE IS CONTENT IN THE "check for details"</a><br/><br/>
<?php else : ?>
  <a href="<?php echo $record['indexPage'] ?>" style="color: #008000">INDEX PAGE LINK IF 'check for details' IS EMPTY</a><br/><br/>
<?php endif ?>

Thanks Damon - that helped me a lot.

An important thing I figured out along the way is that you have to label additional queries as "field1", "field2" etc.

I was trying to figure out why this wouldn't work:

$searchTables['investments'] = array(
'viewerUrl' => 'detail-investments.php',
'titleField' => 'title',
'summaryField' => 'content',
'searchFields' => array('title','content','details'),
'field1' => 'permalink',
'check' => 'details',
);

and determined that just changing it to this solved my problems...

$searchTables['investments'] = array(
'viewerUrl' => 'detail-investments.php',
'titleField' => 'title',
'summaryField' => 'content',
'searchFields' => array('title','content','details'),
'field1' => 'permalink',
'field2' => 'details',
);