Bug #7078

return numrows on $p->query($query);

Details

Request #7078	return numrows on $p->query($query);
Submitted	2006-03-09 17:31 UTC
From	cn at experia dot de
Status	No Feedback
Package	DB_DataObject
PHP Version	4.3.11
OS	linux
Roadmaps	(Not assigned)

Comments

[2006-03-09 17:31 UTC] cn at experia dot de

Description:
------------
return numrows on $p->query($query);

like it is done on $p->find();

to avoid code like :

$query = "SELECT COUNT(certs.Id) AS numrows
FROM certs
LEFT JOIN projects ON (certs.projectId = projects.Id)
LEFT JOIN clients ON (projects.clientId = clients.Id)
WHERE certs.Id >0 $resellerQuery order by certs.Id";

$p = new Certs ( );
$p->query($query);
$p->fetch();
$total=$p->numrows;
print "$total registers found<br>";