Exemplos de HTML_cbodb::showBicycleTransactions em PHP

Exemplo n.º 1

Arquivo: cbodb.functions.php Projeto: reeleis/ohiocitycycles

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);
    }
}