Adding COUNTS of multiple columns
Okay, I have learned that you cannot simply list a bunch of columns in a SELECT COUNT statement and expect it to work.
i.e. SELECT COUNT(images1,images2,images3) FROM members (which I guess really doesn't makes sense anyway)
I would think it's a pretty common thing to add the COUNTS of several columns in a table together and have found a plethora of articles on it, all different and none simple enough to makes sense to me.
Is there a common model that simply adds the COUNTS of column1 + column2 + column3?
If not what is the best practice? I thought about creating a single SELECT COUNT recordset for each column and then using php tp add them all up. However I have 10 columns that need to be added and I think I could do this easier than creating 10 more recordsets.
Thanks for your advice.