You want see the counting number of ORI field or want see all records result from the SQL execution? Sorry if I have some persepsion about your explanation. Thanks. Fajar Dhumadi --- In php-objects@xxxxxxxxxxxxxxx, "Ken" <ken.poyser@...> wrote: > > 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 >
