Category page shows just 5 records...

4 posts by 2 authors in: Forums > CMS Builder
Last Post: August 5, 2011   (RSS)

By mbareara - July 22, 2011

Hi :-)
i have a problem on this page http://calciorosanero.com/news/index.php

It shows me just last 5 records and not all records...

The php code is

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


// load viewer library
$libraryPath = 'cmsAdmin/lib/viewer_functions.php';
$dirsToCheck = array('/home/calciorosanero/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($newsRecords, $newsMetaData) = getRecords(array(
'tableName' => 'news',
));

?>

Thank you for your suggestion :-)
Orazio

Re: [orazio] Category page shows just 5 records...

By Jason - July 22, 2011

Hi Orazio,

Could you add the debugSql to the getRecords function like this:

// load records
list($newsRecords, $newsMetaData) = getRecords(array(
'tableName' => 'news',
'debugSql' => true,
));

This will output the actual query being executed. Could you post what the output is and we can see what's happening.

Hope this helps
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

Re: [Jason] Category page shows just 5 records...

By mbareara - August 5, 2011 - edited: August 5, 2011

hum it doesn.t work...

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


// load viewer library
$libraryPath = 'cmsAdmin/lib/viewer_functions.php';
$dirsToCheck = array('/home/calciorosanero/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($newsRecords, $newsMetaData) = getRecords(array(
'tableName' => 'news',
'debugSql' => true,
));

?>
in
http://calciorosanero.com/news/index.php