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. 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. Link to comment https://forums.phpfreaks.com/topic/215018-league-table-help/#findComment-1118615 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.