[Solved] Counting records

[musicscore]

I want to count record but it doesn't work.
My code is :

Code: Select all

	$query = 'SELECT COUNT(*) AS number FROM '.cms_db_prefix().'module_mfm_billing WHERE filename = ?';
    $dbresult = $db->Execute($query, array($filename));
	
	$countrecords = mysql_num_rows($dbresult); 

$countrecords stays empty

In my test I use a filename that is 2 time in the database.
When I look in the database there 2 records

Please help.

[Jos]

your query is wrong. Check http://dev.mysql.com/doc/refman/5.0/en/ ... tions.html

[Duketown]

musicscore,

Since you seem to be doing this from CMSMS I would stick with the functions available in CMSMS. There for I would write it something like this:

Code: Select all

$query = 'SELECT COUNT(*) AS number FROM '.cms_db_prefix().'module_mfm_billing WHERE filename = ?';
$dbresult = $db->GetRow($query, array($filename));
if ($dbresult) {
      $countrecords = $dbresult['number'];
}

It is not clear if the variable $filename is filled when you start the query, so that might be causing the problem as well.

Duketown

[musicscore]

Thanks Duketown

It is working.

Musicscore

(PS. See you on the 5th Dutch CMSMS Meeting. Any News ??)