function showBicycleTransactions($tag, $option) { $db =& JFactory::getDBO(); $query = "SELECT\n SQL_CALC_FOUND_ROWS\n t.*,\n m.nameFirst,\n m.nameLast\n FROM\n #__cbodb_transactions t,\n #__cbodb_members m\n WHERE\n t.itemID = {$tag} AND\n t.memberID = m.id"; $db->setQuery($query); $rows = $db->loadObjectList(); //$result = $db->loadResult(); if ($db->getErrorNum()) { echo $db->stderr(); return false; } if (count($rows) > 0) { HTML_cbodb::showBicycleTransactions($option, $rows); } }