mod_latestcomment: how to get from contenid to content title?

lunarum · **Posted:** Sun Jan 22, 2006 10:26 am

The "latest comment"-module interacts with the AkoComment-component to display the name of the commenter, the title of his/her comment and the first 100 signs of the comment. I also want it to display the title of the content item to which the comment relates. In the source the ID of the content item (stored in the _content table) is known, so basically my question boils down to:
How do I get from the contentid (numerical value) to display the content item title?

For example: John comments on an article "Fishing is stupid" (with the id 61 in the _content table). I want the "latest comments"-module to display: "John (Fishing is stupid): blahdiblah". HOW DO I DO THIS? I can't get it to work... Please help!

lunarum · **Posted:** Sun Jan 22, 2006 12:38 pm

BTW: I got the code looking something like this now:

Code:

$query = "SELECT title AS contentitemtitle FROM #__content "
         . "WHERE id = $row->contentid";

 $database->setQuery($query);

So how can I now create a variable $contentitemtitle which holds the title of the content item the comment relates to?
I've already tried adding:

Code:

$contentitemtitle = $database->loadObjectList();

but that doesn't do the trick. It returns "Object id#", although the query (in phpMyadmin) seems to work...
As you can probably notice, I'm not that much of an adept at PHP and SQL, so does somebody have an idea on how to solve this problem?

lunarum · **Posted:** Mon Jan 23, 2006 12:21 am

lunarum wrote:

Code:

$contentitemtitle = $database->loadObjectList();

but that doesn't do the trick. It returns "Object id#", although the query (in phpMyadmin) seems to work...
As you can probably notice, I'm not that much of an adept at PHP and SQL, so does somebody have an idea on how to solve this problem?

OMFG! H4X0R! I did it on my own! Hurray for me! (excuse my enthousiasm) The query I made worked. All I needed to do was change the quoted code to:

Code:

$contentitemtitle = $database->loadResult();

This loads the first cell of the first row of the result of the query in stead of presenting it as an object.
Well, my question is answered now, but thanks anyway!

padexx · **Joined:** Thu Sep 22, 2005 2:09 pm **Posts:** 17

would you be so kind to post your complete solution?

'cause I am a beginner when it comes to php.

Thanks!

lunarum · **Posted:** Tue Feb 14, 2006 4:29 pm

In the file mod_latestcomment.php I changed the following lines:

Code:

   $content .= "<tr><td valign='top'><img src='modules/mod_latestcomments/bullet.gif' alt=' '/>
<a href=\"index.php?option=content&task=view&id=".$row->contentid."\"> <b>".$row->title."</b></a>";
    $content .= "<br /><font class='smalldark'>".$row->comment."</font>";
    if ($showname) $content .= "<br /><b>Posted by: </b><font class='smalldark'>".$row->name."</font>";
   if ($date) $content.= "<br />[".$row->date."]";
    $content .= "</td></tr>";

to:

Code:

     // second query to find contentitemtitle with the corresponding contentitemid
     $query2 = "SELECT title AS contentitemtitle FROM #__content "
           . "WHERE id = $row->contentid";

     // run second query
     $database->setQuery($query2);
     $contentitemtitle = $database->loadResult();

        // print results to html-code
   $content .= "<tr><td valign='top'><a href=\"index.php?option=com_content&task=view&id=".$row->contentid.
"\"> ".$row->name."</a> <b>(".$contentitemtitle."):</b> ";
    $content .= "<font class='smalldark'>".$row->comment."</font>";
    $content .= "</td></tr>";

This code will publish your latest comments like the aformentioned "John (Fishing is stupid): blahdiblah" (so including the brackets and colon). Hope this'll help you out!

padexx · **Joined:** Thu Sep 22, 2005 2:09 pm **Posts:** 17

perfect!

Thanks!

erock · **Joined:** Mon Dec 05, 2005 5:21 pm **Posts:** 6

I was looking to do the same thing. Thanks for doing all the hard work for me. I owe you!

Joomla! Discussion Forums

Forum rules

mod_latestcomment: how to get from contenid to content title?

Quick reply

Who is online