Pulling in titles to create sub navigation

5 posts by 2 authors in: Forums > CMS Builder
Last Post: May 18, 2011   (RSS)

By Kittybiccy - May 16, 2011

I've got my site pulling in titles to create a sub navigation. This seems to be working fine in some sections but in the 'portfolio' section on the detail pages it pulls in the records fine as navigation but then displays only the fist entry on every detail page within that section.

I guess this is due to this bit :
// load records
list($residentialRecords, $residentialMetaData) = getRecords(array(
'tableName' => 'residential',
));
$residentialRecord = @$residentialRecords[0]; // get first record

Any ideas how I need to change the code to display all records on each's relevant page? Here is the link to the test site: http://domain3318720.sites.fasthosts.com/portfolio_residentialList.php It's displaying record one on every detail page.

Thanks in advance guys! [:)]

Re: [Kittybiccy] Pulling in titles to create sub navigation

By Jason - May 16, 2011

Hi,

I took a look at your page, and what's happening is your showing the same record for each detail page. To show the correct record for each page, try this:

// load records
list($residentialRecords, $residentialMetaData) = getRecords(array(
'tableName' => 'residential',
'where' => whereRecordNumberInUrl(),
));

$residentialRecord = @$residentialRecords[0]; // get first record

Is that closer to what you're looking for?
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

Re: [Kittybiccy] Pulling in titles to create sub navigation

By Jason - May 17, 2011

Hi,

I assume that in addition to showing all the titles, you also want to display the details of a given selection. Is that right?

If so, what you can do is have 2 queries: 1 that returns just the selected record, and 1 that returns all of the records.

For example:

// get Detail Record
list($residentialDetailRecord, $residentialDetailMetaData) = getRecords(array(
'tableName' => 'residential',
'where' => whereRecordNumberInUrl(),
));

$residentialDetail = @$residentialDetailRecord[0]; // get first record

// get all records from section
list($residentialRecords, $residentialMetaData) = getRecords(array(
'tableName' => 'residential',
'allowSearch' => false,
));

In this example, you have the variable $residentialDetail that is the individual record that was selected, and $residentialRecords that is all the records in your "residential" section.

Hope this helps.
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

Re: [Jason] Pulling in titles to create sub navigation

By Kittybiccy - May 18, 2011

Brilliant, just what I needed! Thank you [:)]