Peter Lauri wrote:
Best groupmember,
I have this query
SELECT count(*) AS number_of_holes, tour_player_score.strokes -
tour_scorecard_hole.par AS overpar
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
It gives me number_of_holes and overpar.
Right now I do this with PHP, but would like to move it to sql directly:
$diff = 0;
While($Row = mysql_fetch_array()) {
If($Row['overpar'])<0) $diff = $diff - $Row['overpar']*
$Row['number_of_holes'];
Elseif($Row['overpar']>=3) diff = $diff - $Row['overpar']*
----------------------------------^
You have an error here.
You miss a ´$´
$Row['number_of_holes'] + 2;
}
Anyway to move this to MySQL and just have one row containing the diff?
Sorry can't give any more comments to that.
Looking forward to see the comments on this.
Greets
Barry
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
