I have a very similar thing I want to accomplish. I was able to get the list page working but I'm having problems with the details page. I need to combine the following.
<?php
require_once "/home/cmsdemo/www/cmsdemo.pixelfusion3.net/cmsAdmin/lib/viewer_functions.php";
list($solutionsRecords, $solutionsMetaData) = getRecords(array(
'tableName' => 'solutions',
'where' => whereRecordNumberInUrl(1),
'limit' => '1',
));
$solutionsRecord = @$solutionsRecords[0]; // get first record
?>
AND
<?php
require_once "/home/cmsdemo/www/cmsdemo.pixelfusion3.net/cmsAdmin/lib/viewer_functions.php";
list($menuRecords, $menuMetaData) = getRecords(array(
'tableName' => 'menu',
'where' => whereRecordNumberInUrl(1),
'limit' => '1',
));
$menuRecord = @$menuRecords[0]; // get first record
?>
I tried the following but it only shows the first item.
<?php
require_once "/home/cmsdemo/www/cmsdemo.pixelfusion3.net/cmsAdmin/lib/viewer_functions.php";
list($solutionsRecords, $solutionsMetaData) = getRecords(array(
'tableName' => 'solutions',
'where' => whereRecordNumberInUrl(1),
'limit' => '1',
));
$solutionsRecord = @$solutionsRecords[0]; // get first record
list($menuRecords, $menuMetaData) = getRecords(array(
'tableName' => 'menu',
'where' => whereRecordNumberInUrl(1),
'limit' => '1',
));
$menuRecord = @$menuRecords[0]; // get first record
?>