Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › COUNT(*) Function

COUNT(*) Function

Thread began 9/03/2015 2:19 am by salaroche | Last modified 10/05/2015 11:31 am by salaroche | 2652 views | 21 replies

9/03/2015 8:22 amNathon Jones Web Design

SELECT ID, Title, COUNT(Type) AS NumberofType
FROM oxadmain
GROUP BY Type

"Type" is your table's category or type field and NumberofType is simply the name you give the count so that you can then display it on your page. You can call this anything you like. You need to use GROUP BY to group the types.

I'll assume this is a recordset you're creating, in which case you'd then display the count on the page as:
<?php echo($RECORDSETNAME->getColumnVal("NumberofType")); ?>

HTH
NJ

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.