ADOdb count number of records

$recordSet = $conn->Execute('SELECT * FROM mytable where published = '.$conn->qstr('1').' or published = '.$conn->qstr('2').' order by id DESC');
$counter = $recordSet->recordCount();
echo $counter;