Sub articles. Is it possibile?

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

By mbareara - March 8, 2011

Hi :-)
i'm building my news site starting from am2.

I really appreciate new features of CmsBuilder. It is .... WOW!!!

But i have a problem:

I want to put, in listviewer, and behind each article two or three related articles choosen by author from article list.

I'vre created a field in 'article' table called 'related_article' as list. Label= article Values= num.

Now in the listviewer i would have

ARTICLE 1
><a href="related article title link">related article title</a>

ARTICLE 2
><a href="related article title link">related article title</a>

I know it is impossibile with left join because related article are in the same table...

Any suggestion?
Thank you in advance :-)
Orazio

Re: [Jason] Sub articles. Is it possibile?

By mbareara - March 12, 2011

Sorry but i don't understand...

I made this

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


// load viewer library
$libraryPath = 'cmsAdmin/lib/viewer_functions.php';
$dirsToCheck = array('/home/siciliatoday/','','../','../../','../../../');
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($articoliRecords, $articoliMetaData) = getRecords(array(
'tableName' => 'articoli',
'leftJoin' => array(
'category' => 'categoria',
),
));

$relatedArticleNums = join( ",", explode( "\t", trim( $record['articoli_correlati_1'], "\t" ) ) );
if(!$relatedArticleNums){ $relatedArticleNums = "0"; }

list( $relatedArticles, $relatedArticlesMetaData ) = getRecords( array(
'tableName' => 'articoli',
'allowSearch' => false,
'where' => "num IN ($relatedArticleNums)",
) );



?>

But it gives me an erorr server...

Re: [orazio] Sub articles. Is it possibile?

By Jason - March 14, 2011

Hi,

You need to do the query that selects the related articles while you're outputting your first set of articles.

If you could attach the .php file you're working with, I can help give you a better example.

Thanks
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com

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