MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: Display sum of table in one line of text?
Posted by: Claude Martin
Date: March 29, 2005 08:24AM

no forget the thing with score+0 it doesnt work anyway

use this instead:

SELECT member, kills, deaths,
IF (deaths, ROUND( kills / deaths, 1 ) , kills) AS score
FROM `matthew`
ORDER BY score

http://animalliberation.tk http://veganismus.ch
http://maqi.de http://tierrechtskochbuch.de

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Display sum of table in one line of text?
Matthew Jones
March 28, 2005 12:30PM
Re: Display sum of table in one line of text?
Claude Martin
March 28, 2005 12:47PM
Re: Display sum of table in one line of text?
Matthew Jones
March 28, 2005 02:43PM
Re: Display sum of table in one line of text?
Claude Martin
March 28, 2005 03:09PM
Re: Display sum of table in one line of text?
Matthew Jones
March 28, 2005 04:11PM
Re: Display sum of table in one line of text?
Matthew Jones
March 28, 2005 04:12PM
Re: Display sum of table in one line of text?
Claude Martin
March 29, 2005 12:14AM
Re: Display sum of table in one line of text?
Claude Martin
March 29, 2005 03:05AM
Re: Display sum of table in one line of text?
Matthew Jones
March 29, 2005 05:29AM
Re: Display sum of table in one line of text?
Claude Martin
March 29, 2005 06:12AM
Re: Display sum of table in one line of text?
Claude Martin
March 29, 2005 06:20AM
Re: Display sum of table in one line of text?
Matthew Jones
March 29, 2005 06:37AM
Re: Display sum of table in one line of text?
Matthew Jones
March 29, 2005 07:58AM
Re: Display sum of table in one line of text?
Matthew Jones
March 29, 2005 08:07AM
Re: Display sum of table in one line of text?
Claude Martin
March 29, 2005 08:19AM
Re: Display sum of table in one line of text?
Claude Martin
March 29, 2005 08:24AM
Re: Display sum of table in one line of text?
Claude Martin
March 29, 2005 08:25AM
Re: Display sum of table in one line of text?
Matthew Jones
March 29, 2005 08:47AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.