The Daily Click ::. Forums ::. General Chat ::. Wierd PHP/MySQL problem
 

Post Reply  Post Oekaki 
 

Posted By Message

Joe.H

Evil Faker

Registered
  19/08/2002
Points
  3305
25th September, 2004 at 07:57:20 -

I'm having trouble with a highscore board. I'm using
mysql_query("SELECT * FROM scores ORDER BY score DESC");
but what it comes out with isn't what i want.

For example, someone could get 8999 and then someone could just get 9 and be at the top of the scoreboard
example: www.scorpione.co.uk/highscores.php?game_id=2

anyone got any ideas how to fix it?

Image Edited by the Author.

 
My signature is never too big!!!

ChrisB

Crazy?

Registered
  16/08/2002
Points
  5457
25th September, 2004 at 09:21:13 -

I get the feeling you're using a string to hold the score when you should be using a number.

 
n/a

Joe.H

Evil Faker

Registered
  19/08/2002
Points
  3305
25th September, 2004 at 09:28:11 -

so I was. Fixed now

Thanks CB

 
My signature is never too big!!!
   

Post Reply



 



Advertisement

Worth A Click