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.

<?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

By MisterJim - October 21, 2008

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
WebCamp One, LLC



Websites That Work