That did work very well, thank you. The DEFAULT value was 0. I am getting closer in my attempt to generate a leaderboard without php :)
________________________________________ From: Gabriel PREDA [mailto:[EMAIL PROTECTED] Sent: Monday, April 10, 2006 7:16 PM To: Peter Lauri Cc: mysql@lists.mysql.com Subject: Re: Do if and elseif and other calculations You can do something like this: SET @diff = 0; SELECT count(*) AS number_of_holes, tour_player_score.strokes - tour_scorecard_hole.par AS overpar, IF(overpar<0, @diff-(overpar*number_of_holes), ELSEVALUE) FROM `tour_player_score`, tour_scorecard_hole WHERE tour_player_id=175 AND tour_scorecard_hole.id=tour_player_score.scorecard_hole_id GROUP BY overpar; And instead of ELSEVALUE you can insert another IF... There is also a CASE in MySQL... you can also use that one... What i don't see here is a DEFAULT value... do you have any ? -- Gabriel PREDA Senior Web Developer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]