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?

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?

Great!

It works, but is there a way to navigate through the records via sort order? Meaning the order they appear in the Admin?

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