Show selected category records

4 posts by 2 authors in: Forums > CMS Builder
Last Post: December 12, 2013   (RSS)

Any thoughts on this guys?

Cheers,

Tim (toledoh.com.au)

By Dave - December 12, 2013

Hi Tim, 

So it sounds like your selected main level is stored in $detailRecord?

If so you could do something like this:

// load records for 'SECTION NAVIGATION'
list($pagesRecords, $pagesMetaData) = getRecords(array(
  'tableName'   => 'pages',
  'orderBy'     => '',   // use default database order
  'loadUploads' => false,
  'allowSearch' => false,
  'where'       => "depth = 1 AND parentNum = '" .mysql_escape($detailRecord['num']). "' ",
));

Note that you'll need to make sure the "parentNum, num, etc" fields match whatever fields you are using.

Let me know if that works for you.

Dave Edis - Senior Developer
interactivetools.com

Perfect Dave - thanks heaps!

Cheers,

Tim (toledoh.com.au)