Database problems showing wrong info

[Zycron]

So I have been scratching my head with this for a week. My database is showing results for things not there as my knowledge with SQL is not great I'll ask here as it's not a website problem. It's a problem with my querry I think here is what it's doing 

Here are the only two entries in my DB

Here is my code.

Thanks all. Any help is appreciated I have tried everything I know including changing sorting orders nothing gets it to read right.

Edited May 15, 2018 by Zycron

[Zycron]

Nevermind fixed it lol.  Bottom of file changed ORDER BY to GROUP BY works like a charm