Count Records

[raouleduke]

I want to find out if all the customers that have only one record in the database, I think that I have been working too long, I am drawing a blank and feeling like a dumbass.

Thanks,

[Weedpacket]

Select username, count(*) as records from the_table group by username

Get all the returned record arrays into one array of $all_the_rows, over which you can array_filter to find and keep those where $all_the_rows[$i]['records']==1

There is undoubtedly at least one better way, but I can't stop thinking about array processing right now.