You need to add the value in the select clause, something like SELECT ORI, count(ORI) as count, Agy_Name .. Richard From: php-objects@xxxxxxxxxxxxxxx [mailto:php-objects@xxxxxxxxxxxxxxx] On Behalf Of Ken Sent: Monday, December 24, 2007 8:22 PM To: php-objects@xxxxxxxxxxxxxxx Subject: [programing] Displaying the count I have a SQL that lists the agencies that have records entered. My SQL is $sql = "SELECT ORI, Agy_Name, Tele_Num from $table_name group by ORI having count(ORI) > 0"; I am wanting to show the "count" as well. I have looked around but I haven't seen anything on how to display the count! Any help would be appreciated! Thanks Ken [Non-text portions of this message have been removed]
