Help needed to add content from multiple sections on one page

Hi PixelFusion,

Try following Dave's instructions in this post (also note the small correction in its following post):

http://www.interactivetools.com/iforum/gforum.cgi?post=64395;search_string=allowSearch%20%3D%3E%20false%2C;t=search_engine#64395

Let us know if that does the trick. [:)]

Hi there

I too am trying to do something similar to this but keep getting an error. My issue: I have a single summary page (tours_summary) and I want to pull data which is on a tours page (page is called tours). I get a broken link message - and am completely baffled! Please help.

Here's the code I'm using:

<?php header('Content-type: text/html; charset=utf-8'); ?>
<?php


// load viewer library
$libraryPath = 'cmsAdmin/lib/viewer_functions.php';
$dirsToCheck = array('/clientdata/n5200-2-dynamic/w/o/worldshores.com.au/www/','','../','../../','../../../');
foreach ($dirsToCheck as $dir) { if (@include_once("$dir$libraryPath")) { break; }}
if (!function_exists('getRecords')) { die("Couldn't load viewer library, check filepath in sourcecode."); }

// load records
list($tours_summaryRecords, $tours_summaryMetaData) = getRecords(array(
'tableName' => 'tours_summary',
'where' => whereRecordNumberInUrl(1),
'limit' => '1',
));
$tours_summaryRecord = @$tours_summaryRecords[0]; // get first record

list($toursRecords, $toursMetaData) = getRecords(array(
'tableName' => 'tours',
'where' => whereRecordNumberInUrl(1),
'limit' => '1',
));
$toursRecord = @$toursRecords[0]; // get first record

// show error message if no matching record is found
if (!$tours_summaryRecord) {
header("HTTP/1.0 404 Not Found");
print "Record not found!";
exit;
}

?>



Thanks

Hi,

What exactly is the error message you're getting? Can you provide a link to the page in question so I can see it in action?

If you could send that information, I can take a closer look at this problem.

Thanks.

Hi Jason
That's the problem - it doesn't display - I get a message saying this page isn't available - see http://www.worldshores.com.au/tourssummary.php

I have attached the full page code as a text file. I have checked the forum, but there is no single conclusive piece of documentation that indicates how to:
1) have a summary page
2) pull data from another section (ie, detailed tours) so that it only displays some of the information on the summary tour page. So when someone clicks on the summary page, they see at a glance a snapshot of all the tours, and can click thru to the details of that tour.
3) I was hoping not to have to duplicate some of the fields from the detailed tour page onto another page, but rather just "pull" it from the "master" detailed tour page.

Is that possible?
Thanks

Hi,

Yes, it is possible, you can pull whatever information you want from the main tours page and only display the information you want.

The problem you're running into is that your queries are not returning any data. You're using this code:

// load records
list($tours_summaryRecords, $tours_summaryMetaData) = getRecords(array(
'tableName' => 'tours_summary',
'where' => whereRecordNumberInUrl(1),
'limit' => '1',
));
$tours_summaryRecord = @$tours_summaryRecords[0]; // get first record

list($toursRecords, $toursMetaData) = getRecords(array(
'tableName' => 'tours',
'where' => whereRecordNumberInUrl(1),
'limit' => '1',
));
$toursRecord = @$toursRecords[0]; // get first record

You're using the "whereRecordNumberInUrl()" function that is looking for a record number in the url string. If it doesn't find one, it returns the number 1. If there is no record number 1, then you're not going to be returning any data.

If you can put the record number of the record you're trying to retrieve at the end of the query string (example: http://www.worldshores.com.au/tourssummary.php?14 ).

Hope this helps.

Hi Jason

Thanks, but that isn't working. The tour_summary is a single page, so by default it should only pull record 1. So, the tours_summary record is a single page, which has a bit of a generic intro, and THEN I want to list the tours in summary form below, taking the data from tours ('tableName' => 'tours',).
How do I make that work?
Thanks in advance.

Carole

Hi Carole,

This is certainly possible, and you're very close to the solution, but I'm concerned about the error you're getting, so let's back up a step.

When I go to [url http://www.worldshores.com.au/tourssummary.php]http://www.worldshores.com.au/tourssummary.php[/url] I get a message saying "Record not found!" From the code you posted above, that should only happen when the tours_summary record hasn't been loaded. Let's forget about your tours section for a moment and get rid of that error. Do you have a working page which displays your tours_summary record? Can you post the complete PHP source code to a working tours_summary page?

Hi Chris

The page is definitely loaded on the webserver. And the view URL is /tours_summary/tourssummary.php which I trust is correct? as the table name is tours_summary

The full code is attached as a txt file. Any light shed on this would be helpful!
Thanks!