10
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;
}
}
?>
More From
» PHP