https://interactivetools.com/forum/forum-posts.php?Pulling-in-titles-to-create-sub-navigation-72572 Mon, 15 Jun 2026 00:47:04 -0700 en-us https://interactivetools.com/forum/forum-posts.php?postNum=2211361#post2211361 ]]> Wed, 18 May 2011 03:59:59 -0700 forum-posts.php?postNum=2211361#post2211361 https://interactivetools.com/forum/forum-posts.php?postNum=2211348#post2211348
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.
]]> Tue, 17 May 2011 11:30:42 -0700 forum-posts.php?postNum=2211348#post2211348 https://interactivetools.com/forum/forum-posts.php?postNum=2211347#post2211347
Thanks, I had tried that before but when you then go into a detail page it only displays that record title in the sub navigation:
http://domain3318720.sites.fasthosts.com/portfolio_residentialList.php

I need it to display all of the record titles for that section on each detail page as it does on the list page. Is that possible? Thanks!
]]> Tue, 17 May 2011 04:32:01 -0700 forum-posts.php?postNum=2211347#post2211347 https://interactivetools.com/forum/forum-posts.php?postNum=2211335#post2211335
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?
]]> Mon, 16 May 2011 11:47:47 -0700 forum-posts.php?postNum=2211335#post2211335 https://interactivetools.com/forum/forum-posts.php?postNum=2211330#post2211330
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! [:)]
]]> Mon, 16 May 2011 06:16:34 -0700 forum-posts.php?postNum=2211330#post2211330