So, after I enter values in all of the score fields & penalties, it does some simple calculations to populate the following fields (Marks, Net results, result total, total & rank) that part works fine. PHP $values = $values + $values + $values + $values + $values + $values + $values + $values + $values + $values + $values + $values + $values + $values + $values + $values + $values + $values + $values + $values + $values + $values $values = $values - $values $values = $values/220 * 100 $values = 100 - $values $values = ($values + $values) * 0.4 $values = $values + $values + $values SQL SELECT ` Number `, ` Rider Name `, ` Horse Name `, Score1, Score2, Score3, Score4, Score5, Score6, Score7, Score8, Score9, Score10, Score11, Score12, Score13, Score14, Score15, Score16, Score17, Score18, Score19, Score20, Score21, Marks, Penalties, ` Net Results `, ` Result Total `, Total, FIND_IN_SET ( Total, ( SELECT GROUP_CONCAT ( DISTINCT Total ORDER BY Total ASC ) FROM ` Dressage scores ` )) AS Rank, Division, ` Time out `, ` Time in `, timediff ( ` Time in `, ` Time out ` ) AS ` Time Elapsed `, ` Speed Fault `, ` Optimum Time `, GREATEST ( TIMESTAMPDIFF ( SECOND, ` Time Elapsed `, ` Speed Fault ` ), 0 ) AS ` Under Time `, GREATEST ( TIMESTAMPDIFF ( SECOND, ` Optimum Time `, ` Time Elapsed ` ), 0 ) AS ` Over Time `, ` Jump penalties `, ` Final Total `, FIND_IN_SET ( ` Final Total `, ( SELECT GROUP_CONCAT ( DISTINCT ` Final Total ` ORDER BY ` Final Total ` ASC ) FROM ` Dressage scores ` )) AS ` Final Rank `, ` Time Elapsed ` AS ` Time Elapsed1 `, ` Final Rank ` AS ` Final Rank1 `, Score22, ` Time Penalties ` FROM ` Dressage scores ` ORDER BY FIND_IN_SET ( Total, ( SELECT GROUP_CONCAT ( DISTINCT Total ORDER BY Total ASC ) FROM ` Dressage scores ` )), FIND_IN_SET ( ` Final Total `, ( SELECT GROUP_CONCAT ( DISTINCT ` Final Total ` ORDER BY ` Final Total ` ASC ) FROM ` Dressage scores ` ))
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |