EchoFool Posted October 3, 2010 Share Posted October 3, 2010 Hey Im trying to calculate a % of completion against a secondary table like so: Total number of rows where Complete = 1 would be a certain % of total number of rows of another table. So say i have 5 rows with Complete = 1 on "table1" and there was 10 rows on "Table2" then this would return 50% but am looking to then order than in DESC order and limit by 20 (i can do the orderby and limit - no problems). But im stuck as to how i would do this in a single query... any one got the faintest idea? Hope you can help. Quote Link to comment https://forums.phpfreaks.com/topic/215018-league-table-help/ Share on other sites More sharing options...
fenway Posted October 3, 2010 Share Posted October 3, 2010 I don't follow. Quote Link to comment https://forums.phpfreaks.com/topic/215018-league-table-help/#findComment-1118615 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.