Back to PhocaGalleryCommentCategory class

Method displayComment

public static
displayComment
(mixed $catid)

Method displayComment - Source code

public static function displayComment($catid)
{
    $db = Factory::getDBO();
    $query = 'SELECT co.id AS id, co.title AS title, co.comment AS comment, co.date AS date, u.name AS name, u.username AS username' . ' FROM #__phocagallery_comments AS co' . ' LEFT JOIN #__users AS u ON u.id = co.userid ' . ' WHERE co.catid = ' . (int) $catid . ' AND co.published = 1' . ' ORDER by ordering';
    $db->setQuery($query);
    $commentItem = $db->loadObjectList();
    return $commentItem;
}