Skipping specific records when using [previous] & [next] code

Hi drewh01,

I'm not sure I quite understand what you're doing. Can you post the complete PHP source code for your page? Preferably as an attachment?

I really don't have much more code to show other than what I pasted in my original message.

What I am trying to do is to use the dynamic [previous] and [next] links to navigate from one record detail page to the next and back.

I am looking for a way to set a specific record to be skipped when navigating through the previous and next links.

For instance:

[previous]

Record 1
Record 2  <---- Skip this detail page
Record 3
Record 4
Record 5

[next]

Hi drewh01,

I'm assuming you're using getPrevAndNextRecords()? You can use a where clause to filter certain results.

// Supported options: tableName (required), recordNum (optional), and orderBy (optional, defaults to schema listPageOrder)
// list($prevRecord, $nextRecord, $firstRecord, $lastRecord) = getPrevAndNextRecords(array(
// 'tableName' => 'news',
// 'recordNum' => $record['num'],
// 'where' => '1', // optional - defaults to all records in section
// 'orderBy' => 'createdDate', // optional - defaults to schema listPageOrder
// ));

For example:

$where = "num != 2";

list($prevRecord, $nextRecord, $firstRecord, $lastRecord) = getPrevAndNextRecords(array(
  'tableName' => 'news',
  'recordNum' => $record['num'],
  'where'     => $where,
));

Does that help?

Thanks!  I'm a bit rusty but here are some of my load records:

What is the best way to add the "where" code?

// load record from 'films'
list($filmsRecords, $filmsMetaData) = getRecords(array(
'tableName' => 'films',
'where' => whereRecordNumberInUrl(0),
'loadUploads' => true,
'allowSearch' => false,
'limit' => '1',
));
$filmsRecord = @$filmsRecords[0]; // get first record
if (!$filmsRecord) { dieWith404("Record not found!"); } // show error message if no record found

//Get prev/next links using the blog num
list($prevRecord, $nextRecord, $firstRecord, $lastRecord) = getPrevAndNextRecords(array(
'tableName' => 'films',
'recordNum' => $filmsRecord['num'],
'orderBy' => 'createdDate'
));

Here:

//Get prev/next links using the blog num 
$where = "num != 2";
list($prevRecord, $nextRecord, $firstRecord, $lastRecord) = getPrevAndNextRecords(array( 
'tableName' => 'films', 
'recordNum' => $filmsRecord['num'], 
'where'     => $where,
'orderBy'   => 'createdDate'
));

Does that help?

Thanks, that really helps.

Finally - how do I change to using one of the fields rather than "num"?

$where = "num != 2";

$where = "title != ??";

For instance, I want only the records that have a title to appear in the previous & next function.

Is this even possible, or is there a better way?

Hi drewh01,

Try this:

$where = "title > ''";

Usually, you can get away with title != '', but that won't catch NULL fields, so the above is safer.

Does that help?

Yes, if you omit the 'orderBy' line, getPrevAndNextRecords() will default to the sort order defined in the Admin.