List Records Trouble
3 posts by 2 authors in: Forums > CMS Builder
Last Post: October 21, 2008 (RSS)
By jposwald - October 21, 2008 - edited: October 21, 2008
Dear IT,
I have a problem listings records.
It only list me the first record, and not the others ones I've add in same category.
In where cause I put num 1 because it's the section of list that I need to show (I have 3 sections for that variable).
It works but only show me the first one.
This is the URL:
http://www.utahreoexperts.com/first-time-home-buyers/faq-frequently-asked-questions/
The code of the list page is:
Thank you!!!!!
I have a problem listings records.
It only list me the first record, and not the others ones I've add in same category.
In where cause I put num 1 because it's the section of list that I need to show (I have 3 sections for that variable).
It works but only show me the first one.
<?php
require_once "/home/content/d/e/rhtml/utahreoexperts/cmsAdmin/lib/viewer_functions.php";
list($frequently_asked_questionsRecords, $frequently_asked_questionsMetaData) = getRecords(array(
'tableName' => 'frequently_asked_questions',
'where' => whereRecordNumberInUrl(1),
'where' => " num = '1' ",
'perPage' => '10',
'loadUploads' => '0',
'allowSearch' => '0',
));
?>
This is the URL:
http://www.utahreoexperts.com/first-time-home-buyers/faq-frequently-asked-questions/
The code of the list page is:
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<?php foreach ($frequently_asked_questionsRecords as $record): ?>
<tr>
<td width="560" height="25" valign="top">
Q. <?php echo $record['question'] ?></td></tr>
<tr>
<td height="25" valign="top">
A. <?php echo $record['answer'] ?></td></tr>
<tr>
<td height="20" valign="top">
<a href="#Top-Page">Back to Top</a></span></td></tr>
<tr>
<td height="3" valign="top"><img src="separator.png" width="560" height="3"></td></tr>
<?php endforeach; ?>
</table>
Thank you!!!!!
Re: [jposwald] List Records Trouble
Take this line out of your header. It would be reserved for the header on your detail page, but it doesn't look like you are going to have a detail page.
'where' => whereRecordNumberInUrl(1),
Jim
'where' => whereRecordNumberInUrl(1),
Jim
WebCamp One, LLC
Websites That Work
Websites That Work
Re: [Mr Jim] List Records Trouble
By jposwald - October 21, 2008
Mr Jim thank your help approach, what i wanted was another thing, but I already found it in post 65540 thank you!!!