Untitled

<?
require_once("lib/MDB2.php");

$conexao = 'mysqli://root:@localhost/24hrs';
$conexao = MDB2::factory($conexao);

$sql = "SELECT * FROM tbEmpresa ORDER BY DfRazao ASC";
$resultset = $conexao->query($sql);

if(PEAR::isError($resultset)) {
       die('Ocorreu um erro na consulta: ' . $resultset->getMessage());
}

$total = $resultset->rowCount();
echo $total;

while($row = $resultset->fetchRow(MDB2_FETCHMODE_ASSOC)) {
       $DfIdCliente = $row["DfIdCliente"];
       $DfRazao = $row["DfRazao"];
       $DfFantasia = $row["DfFantasia"];

       echo "$DfIdCliente $DfRazao $DfFantasia<br />";
}

$conexao->disconnect();
?>