Displaying Results

Hi Ross!

I think that is how i have it set up right now. But I actually need everything all mixed together. 

- Shawn

Hi,

Im just wondering if anyone else had any thoughts on this. I've been looking at it more, and I am pretty stumped.

Hi shawnpatoka,

I think it's more difficult and complicated to have to deal with merging and sorting the two recordsets. If you can get away with it (and it seems like you can in this case,) you may find it easier to use a single getRecords() call and split the list apart by skipping over records using IF and CONTINUE. Here's an example of what I mean:

<?php header('Content-type: text/html; charset=utf-8'); ?>
<?php require_once "cmsAdmin/lib/viewer_functions.php"; ?>
<?php if (!@$GLOBALS['GEOCODER_PLUGIN']) { die("You must activate the Geocoder plugin before you can access this page."); } ?>
<?php

  $kmOrMiles = 'miles'; // can be 'miles' or 'km'

  // set default values
  if (!array_key_exists('fromAddress', $_REQUEST)) { $_REQUEST['fromAddress'] = '10001'; }      // this is the default address/postalcode if none entered
  if (!@$_REQUEST['maxDistance'])                  { $_REQUEST['maxDistance'] = '50000'; } // this will include all results

  // get coordinates
  list($myLat, $myLng) = geocodeAddress( @$_REQUEST['fromAddress'] );

  // error checking
  $errorsAndAlerts = '';
  if (@$_REQUEST['search']) {
    if     (!@$_REQUEST['fromAddress']) { $errorsAndAlerts .= "No address entered!<br/>\n"; }
    elseif (!$myLat || !$myLng)         { $errorsAndAlerts .= "We couldn't determine your location, please try again!<br/>\n"; }
  }

  // get records
  $addressRecords = array();
  if ($myLat && $myLng) {
    $maxDist = floatval(@$_REQUEST['maxDistance']);
    list($addressRecords, $addressMetaData) = getRecords(array(
      'tableName'     => 'participating_bars',
      'addSelectExpr' => geocoder_getSelectExprForDistance($myLat, $myLng, '_distance', $kmOrMiles), // adds '_distance' field to output records
      'where'         => geocoder_getWhereForDistanceWithin($myLat, $myLng, $maxDist, $kmOrMiles),   // optimization: remove results outside of minimum bounding rectangle
      'having'        => "_distance <= " . $maxDist, // only show results within max distance
      'orderBy'       => 'ISNULL(_distance), _distance', // sort nearest records first -and- unknown or undefined distances last
    ));
  }

?>

List in order by distance:
<ul>
  <?php foreach ($addressRecords as $record): ?>
    <li><?php echo htmlencode($record['title']) ?></li>
  <?php endforeach ?>
</ul>

List in order of stars:
<ul>

  <!-- first, only list platinums by skipping over everything that doesn't have the 'platinum' field checked -->
  <?php foreach ($addressRecords as $record): ?>
    <?php if (!$record['platinum']) { continue; } ?>
    <li><?php echo htmlencode($record['title']) ?></li>
  <?php endforeach ?>

  <!-- next, only list golds by skipping over everything that doesn't have the 'gold' field checked -->
  <?php foreach ($addressRecords as $record): ?>
    <?php if (!$record['gold']) { continue; } ?>
    <li><?php echo htmlencode($record['title']) ?></li>
  <?php endforeach ?>

  <!-- next, only list silvers by skipping over everything that doesn't have the 'silver' field checked -->
  <?php foreach ($addressRecords as $record): ?>
    <?php if (!$record['silver']) { continue; } ?>
    <li><?php echo htmlencode($record['title']) ?></li>
  <?php endforeach ?>

  <!-- finally, list everything else by skipping over everything that has either the 'platinum', 'gold', or 'silver' field checked -->
  <?php foreach ($addressRecords as $record): ?>
    <?php if ($record['platinum'] || $record['gold'] || $record['silver']) { continue; } ?>
    <li><?php echo htmlencode($record['title']) ?></li>
  <?php endforeach ?>

</ul>


Does that help?

Hi Chris, 

Thanks for helping me out! I really appreciate it.

But with your bottom example, that would essentially group the starred items on top and the rest below? The 'Silver' , 'Gold' ,and 'Platinum' are basically just names for templates. 'Platinum' results would link to a.php(then the record link), 'Gold' results would link to b.php(then the record link), and Silver would link to c.php(then the record link).    But when someone types in their zip code on the homepage, the results should be in order by distance, not if they are a starred listing or not. That's where i think it would get hard, because some of the results should not be links and some should link to a.php(then the record link), some should link to b.php(then the record link), and some c.php(then the record link).

Your top one would be ideal, but how could i get certain ones to link to certain templates, and some not link anywhere?

Let me know if this makes sense or not, or if Im just explaining it weird lol.

Thanks again!

Hi shawnpatoka

Just to do an overly simplified re-cap of what you are looking for, you need your results to be ordered by distance and then have them load into different templates based on whether they are gold, silver or platinum.  

If that's the case, Chris has you on the right track with using just one getRecords and it sounds like you are on the same track with him at that stage.  So now that we have just one getRecords, to get the results loading into a different template based on their gold, silver or platinum status, you can use some simple ifs. What I am thinking is something like this:

<?php 

foreach ($resultsRecords as Rrecord) {

... all your code goes here ...

//

if ($record['gold']) { echo "<a href='gold.php?". $record['num'] ."'>Read More</a>";
if ($record['silver']) { echo "<a href='silver.php?". $record['num'] ."'>Read More</a>";
if ($record['platinum']) { echo "<a href='platinum.php?". $record['num'] ."'>Read More</a>";

}

You'll of course need to make sure you have the appropriate variable in there for $resultsRecord.  Other than that, the if's are pretty straight forward. 

Does this make sense?  And if it does, do you feel like I am on the right track here?

Let me know any questions. Thanks!

Hi,

I'm not on my regular computer to test it out, but that does look like it should work.

thank you guys very much! I really appreciate it.