Searching for more than one similar and then count
I have a table with people (tbl_people).
Containing name, address, city, country.
I would like to search this mysql db for all people who lives in either france, germany or belgium.
Then I would like the code to count all the hits. If it finds 20 people in france, 30 in germany and then 10 in belgium, I would like it to tell me it found 60 people.
I'm not sure how to do this, but it's probably very simple.
What is the shortest way to do it (and quickest)?
When I try this type of code I always tend to do it a very, very stupid way and I end up with a lot of lines in my code.
But with all people out here, there is usually a very quick and simple answer to my question.