Database query: number of rows returned?
Permalink 1 user found helpful
Building my own PHP scripts to go into a custom block. What's the 'correct' method to find the number of rows returned from a query. Have looked in what I think is the database abstraction file (concrete/libraries/database.php), but it seems very minimal.
concrete5 uses ADODB, when you get the rows you can do
$myvalue = 25; // this gets us the database object $db = Loader::db(); // adodb query with binding to escape // variable $rs = $db->Execute('SELECT somevalue FROM sometable WHERE something=?', array($myvalue)); // This gives us the count // or -1 for none; // can also use RowCount() $count = $rs->RecordCount();