Joomla 1.5: пример работы с БД

$getdb=&JFactory::getDBO();
$q="SELECT mfo FROM jos_users WHERE mfo!='0'";
$getdb->setQuery($q);
$arr=$getdb->loadResultArray();

$q="SELECT username, mfo FROM jos_users WHERE mfo!='0'";
$arr=$getdb->loadObjectList();
foreach ($arr as $a) {
	$mfo=$a->mfo; $username=$a->username;
}