Skip to main content
M
matthew stuart
Inspiring
April 19, 2013
Question

Count the total amount of records returned

  • April 19, 2013
  • 1 reply
  • 658 views

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.

This topic has been closed for replies.

1 reply

B
bregent
Participating Frequently
April 19, 2013

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

M
matthew stuartAuthor
Inspiring
April 19, 2013

PHP/MySQL.

B
bregent
Participating Frequently
April 19, 2013

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

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

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices