Highub – IT Web Tips

mysql_fetch_assoc is the native PHP MySQL function to fetch a result row as an associative array. Joomla! has it’s own database abstraction class that does this job — loadAssoc.

Below is an example of the using loadAssoc to fetch a result row from content table and show the individual selected field results:

$db = JFactory::getDBO();
$query = "SELECT * FROM #__content WHERE
title='Overview'";
$db->setQuery($query);
$article_row = $db->loadAssoc();
echo $article_row['introtext']."—".$article_row['publish_up'];

The output will the the intro text of the article with the title Overview and followed by published date and time.