Raised This Month: $ Target: $400
 0% 

Mysql top


  
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
Stenudd
Junior Member
Join Date: Nov 2010
Location: Sweden
Old 05-30-2011 , 15:30   Re: Mysql top
Reply With Quote #21

Quote:
Originally Posted by Hunter-Digital View Post
Also, that query looks weird... what's wrong with using:
Code:
SELECT rank, (SELECT COUNT(*) FROM stats) AS total, kills, deaths, headshots, skill FROM stats WHERE steam='%s'
?
The query is perfectly fine, what it does is that it calculates the skills on the fly.

However I most have missed something, don't you wanna calculate the skills on the fly anymore? As you added a own field called skills
__________________
Stenudd is offline
 



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 00:29.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode