List inside the details page
2 posts by 2 authors in: Forums > CMS Builder
Last Post: November 2, 2012 (RSS)
By Mohaukla - November 1, 2012
I have my list page that shows each section (documents and their uploads)
When clicking on a document link for the details page it works correctly but I have also included a list of the other documents from that section.
The problem is that the list ends up being only 1 document and it's the same one that is showing up in the details.
I am sure this is a simple fix but I cannot seem to find the solution.
DETAILS PAGE: http://www.capstanag.com/presentations_full.php?Test-Presentation-1
Then in the page
When clicking on a document link for the details page it works correctly but I have also included a list of the other documents from that section.
The problem is that the list ends up being only 1 document and it's the same one that is showing up in the details.
I am sure this is a simple fix but I cannot seem to find the solution.
DETAILS PAGE: http://www.capstanag.com/presentations_full.php?Test-Presentation-1
require_once "C:/Webspace/resadmin/mmoyers/capstanag.com/www/cmsAdmin/lib/viewer_functions.php";
list($presentations_powerpointsRecords, $presentations_powerpointsMetaData) = getRecords(array(
'tableName' => 'presentations_powerpoints',
'allowSearch' => '0',
));
list($presentations_powerpointsRecords, $presentations_powerpointsMetaData) = getRecords(array(
'tableName' => 'presentations_powerpoints',
'where' => whereRecordNumberInUrl(1),
'limit' => '1',
));
$presentations_powerpointsRecord = @$presentations_powerpointsRecords[0]; // get first record
// show error message if no matching record is found
if (!$presentations_powerpointsRecord) {
header("HTTP/1.0 404 Not Found");
print "Record not found!";
exit;
}
Then in the page
<div class="text" style="padding-left:10px; padding-top:10px; padding-right:15px">
<span class="Titles">Presentations / PowerPoints: <?php echo $presentations_powerpointsRecord['title'] ?></span>
<p class="text">
<?php echo $presentations_powerpointsRecord['content'] ?><br />
<?php foreach ($presentations_powerpointsRecord['powerpoint_upload'] as $upload): ?><a href="<?php echo $upload['urlPath'] ?>"><strong>DOWNLOAD</strong></a><?php endforeach ?><p> </p>
</p>
<p class="SubTitles">All Presentations:
</p>
<?php foreach ($presentations_powerpointsRecords as $record): ?>
<p><span class="SubTitles"><?php echo $record['title'] ?>:</span><br />
<?php foreach ($record['powerpoint_upload'] as $upload): ?> <a href="<?php echo $upload['urlPath'] ?>">Download</a><?php endforeach ?> - <a href="<?php echo $record['_link'] ?>">More Information</a>
</p>
<?php endforeach ?>
<br /><br />
</div>
Michael Moyers
Owner of Just Rite Design Inc. A growing network of professionals in web design, graphic design, flash development, programming, and audio & video productions.
"Due to budget constraints, the Light at the end of the tunnel will be temporarily out!"
Owner of Just Rite Design Inc. A growing network of professionals in web design, graphic design, flash development, programming, and audio & video productions.
"Due to budget constraints, the Light at the end of the tunnel will be temporarily out!"
Re: [justritedesign] List inside the details page
Hi Michael,
I think I can see the problem. At the top of the page you have two getRecords functions that are using the same variable to store the retrieved data. I think you just need to rename the second variable. Something like this should work:
Let me know if it doesn't work
Thanks!
I think I can see the problem. At the top of the page you have two getRecords functions that are using the same variable to store the retrieved data. I think you just need to rename the second variable. Something like this should work:
<?php
require_once "C:/Webspace/resadmin/mmoyers/capstanag.com/www/cmsAdmin/lib/viewer_functions.php";
list($allRecords, $presentations_powerpointsMetaData) = getRecords(array(
'tableName' => 'presentations_powerpoints',
'loadUploads' => true,
'allowSearch' => false,
));
list($presentations_powerpointsRecords, $presentations_powerpointsMetaData) = getRecords(array(
'tableName' => 'presentations_powerpoints',
'where' => whereRecordNumberInUrl(1),
'limit' => '1',
));
$presentations_powerpointsRecord = @$presentations_powerpointsRecords[0]; // get first record
// show error message if no matching record is found
if (!$presentations_powerpointsRecord) {
header("HTTP/1.0 404 Not Found");
print "Record not found!";
exit;
}
?>
<div class="text" style="padding-left:10px; padding-top:10px; padding-right:15px">
<span class="Titles">Presentations / PowerPoints: <?php echo $presentations_powerpointsRecord['title'] ?></span>
<p class="text">
<?php echo $presentations_powerpointsRecord['content'] ?><br />
<?php foreach ($presentations_powerpointsRecord['powerpoint_upload'] as $upload): ?><a href="<?php echo $upload['urlPath'] ?>"><strong>DOWNLOAD</strong></a><?php endforeach ?><p> </p>
</p>
<p class="SubTitles">All Presentations:
</p>
<?php foreach ($allRecords as $record): ?>
<p><span class="SubTitles"><?php echo $record['title'] ?>:</span><br />
<?php foreach ($record['powerpoint_upload'] as $upload): ?> <a href="<?php echo $upload['urlPath'] ?>">Download</a><?php endforeach ?> - <a href="<?php echo $record['_link'] ?>">More Information</a>
</p>
<?php endforeach ?>
<br /><br />
</div>
Let me know if it doesn't work
Thanks!
Greg Thomas
PHP Programmer - interactivetools.com
PHP Programmer - interactivetools.com