Exemplos de HTML_cbodb::listMemberNames em PHP

Exemplo n.º 1

Arquivo: cbodb.php Projeto: reeleis/ohiocitycycles

function listMemberNames($option)
{
    $db =& JFactory::getDBO();
    $query = "SELECT id,nameFirst,nameLast FROM #__cbodb_members WHERE nameFirst LIKE '" . JRequest::getVar("firstletter") . "%' ORDER BY nameFirst,nameLast";
    //$query = "SELECT id,nameFirst,nameLast FROM #__cbodb_members";
    $db->setQuery($query);
    $rows = $db->loadObjectList();
    if ($db->getErrorNum()) {
        echo $db->stderr();
        return false;
    }
    HTML_cbodb::header();
    HTML_cbodb::listMemberNames($option, $rows);
}