Hi give the table structure and sample data Thanks, Muthukumar Selvarasu, Project Manager (Web Development), Webmasters Ltd. _____ From: php-objects@xxxxxxxxxxxxxxx [mailto:php-objects@xxxxxxxxxxxxxxx] On Behalf Of Ken Sent: Tuesday, December 25, 2007 1:22 PM To: php-objects@xxxxxxxxxxxxxxx Subject: 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]
