• 0
Sign in to follow this  
Zycron

Database problems showing wrong info

Question

Posted (edited)

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 

Flux Control Panel_ PvP Ranking - Google Chrome 5_15_2018 2_09_33 PM.png

Here are the only two entries in my DB

Mine_ragnarok_main_pvpladder_ - HeidiSQL 9.1.0.4867 5_15_2018 2_09_29 PM.png

Here is my code.

C__xampp_htdocs_unro_modules_ranking_pvpranking.php - Notepad++ 5_15_2018 2_09_01 PM.png

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

Edited by Zycron

Share this post


Link to post
Share on other sites

1 answer to this question

Recommended Posts

  • 0

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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this