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: [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!!!