Anomoly in recordset results

I have an odd one here. Well, it seems odd on first look, but is the end of the day.

I have three pages, one that shows all records (index_wa1.php, attached), one that shows records which have a country (index_wa2.php, attached), and one that shows records where the country field is blank (index_wa3.php, attached).

So index_wa1.php returns 5530 records. I would expect the sum of the other to to add up to 5530, as they all either have a country, or don't have a country. However, they add up to 5491, a discrepancy of 39.

Its not the end of the world, but it would be good to know why that was if it wasn't too much of a pain to figure out.

My only guess is that if someone has multiple rows in a joined table it could meet both criteria. So one row has a blank Country and the other has an entry, so that particular record can be returned for both cases.

Thanks for having a look.

If a record was returned in both cases, would that not make the total add up to more than the 5530 records though? Which would probably make sense like you say, ie a bit of double counting somewhere. But they are adding up to less then the 5530 records.

I'll play around with the SQL in phpMyAdmin and see if I can spot what's up.

I've updated the no country page to show all records where country = '' or country IS NULL. That has gotten the number even closer and now it adds up to 3 more than the total, which could be the repeat count issue I mentioned above.