Featured rental listings

Hi Kate

Thanks for posting!

The best way to do that would be to create a checkbox field called "Featured" in each section.

On your front page, you would just need to setup a list viewer for each section that only displays one record that has the featured box checked. You'll likely want to set these two viewers to sort by last updated time so that only the most recently featured listing shows up. That way, you don't have to worry about unchecking it on old listings.

Get those two fields setup and then let me know. I can try walking you through the whole thing if you like, or we can move over to consulting and I'll just do it for you myself.

Thanks!

Thanks Ross. I'll be able to do it, just need to know what to write to get it to sort by last updated time.

Thanks!

Hi Kate

When you are generating the code for the featured listing viewer, make sure you check off the Advanced setting for Record Sorting. In the text field put "updatedDate DESC" and that should be it. In the viewer code, you'll see this up at the top:

'orderBy' => 'updatedDate',

Let me know if this gets things going. Thanks!

Almost there :)

Got it working and displaying the featured listing, but it doesn't change if I specify another listing as the featured after any others I have selected. I assume the problem is the header as I wasn't sure what to put there to get only featured ones to display >>

<?php
require_once "/mysite/viewer_functions.php";

list($salesRecords, $salesMetaData) = getRecords(array(
'tableName' => 'sales',
'where' => whereRecordNumberInUrl(1),
'limit' => '1',
'where' => ' featured = "1" ',
'orderBy' => 'updatedDate',

));
$salesRecord = @$salesRecords[0]; // get first record

?>

Hi Kate.

A couple things I can suggest here. First, remove this line:

'where' => whereRecordNumberInUrl(1),

Second, try changing:

'orderBy' => 'updatedDate',

to:

'orderBy' => 'updatedDate ASC',

or

'orderBy' => 'updatedDate DESC',

Let me know if this helps :).

Woohoo! When I got rid of the where, and used 'orderBy' => 'updatedDate DESC' it worked like a charm.

Thanks Ross!