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.