Adodb RecordCount( ) Examples

rated 10 times [ 10] [ 0] / comments: 0 / hits: 2447 / 3 years ago, thu, dec 1, 2016, 18:27:26

Count number of rows in the record set

<?php
//example 1
$ra = $DB->execute('SELECT * FROM articles WHERE id = '.$DB->qstr($id).'');
if(!$ra)
 print $DB->ErrorMsg();
else
 while(!$ra->EOF) {
  $numrows = $ra->PO_RecordCount();
  echo $numrows;
  //$title = $ra->fields['title'];
  $ra->MoveNext();
 }
?>

<?php
//example 2
$ra = $conn->Execute('SELECT * FROM articles WHERE id = '.$DB->qstr($id).'');
if($ra) {
 if($ra->fields > 0) {
  $numrows = $ra->PO_RecordCount("articles");
  echo $numrows;
 }
}
?>