count rows inside array
View Single Post
12-03-2012, 08:50 PM
Supreme Master coder!
Join Date: Feb 2009
Thanked 4,310 Times in 4,277 Posts
I also used AND state !='' for empty state values...
That's good, but better would be
AND IFNULL(state,'') != ''
That will handle state values that are either a blank string ('') or NULL in the DB. A safer test, over all.
An optimist sees the glass as half full.
A pessimist sees the glass as half empty.
A realist drinks it no matter how much there is.
View Public Profile
Find More Posts by Old Pedant