[MOD] Dont need to query again just for get article title

Forums

Please write a review for the extension you are using on the Joomla extensions directory before posting a new question as we are being spammed by many negative reviews.

Thank you for your support!

[MOD] Dont need to query again just for get article title

SoulEvil 22 Nov, 2008

$query = "SELECT a.*, b.id as articleid, b.catid as catid, b.sectionid as secid, b.title AS articletitle FROM #__chrono_comments AS a, #__content AS b WHERE a.pageid = b.id AND a.published='1' AND a.verify='1'".$extra." ORDER BY a.datetime ".$params->get( 'order', 'ASC' )." LIMIT 0,".$params->get( 'commentscount', 5 );

//get full article link

			$page_link = JRoute::_(ContentHelperRoute::getArticleRoute($commentx->articleid, $commentx->catid, $commentx->secid));

			//end article link

So you don't need to take query again just for each article

Max_admin 22 Nov, 2008

Thanks for the suggestion, I will check this mod before the next release for sure!

Regards,
Max

Max
ChronoForms developer...
Did you try ChronoMyAdmin for managing your Joomla database tables ?

This topic is locked and no more replies can be posted.