Count the total amount of records returned

[matthew stuart]

Is there a way in DW to count and display the total amount of records in my DB table?

Eg: I might have 10,000 records in my database, but only 55 match the SELECT statement, so I want to show a visual counter saying '55 articles in this section' on my page.

[bregent]

All recordsets contain a property that contains the rowcount. What scripting language are you using?

[matthew stuart]

PHP/MySQL.

[bregent]

Choose one of these  function appropriate to the api you are using:

http://php.net/manual/en/function.mysql-num-rows.php