I have written a function to get all the users details from a 2 table. This is the code
//get all the diff each users
$db->query("SELECT DISTINCT (user_fb_id )FROM users_points WHERE users_points.match_id >= '$matchId'");
$distinctUsers = $db->resultsArray;
foreach($distinctUsers as $key=>$user){
$db->query("SELECT SUM(points) AS totalPoints FROM users_points WHERE user_fb_id = '{$user['user_fb_id']}' AND match_id >= '$matchId' ORDER BY totalPoints DESC");
$result[$key]['user_fb_id'] = $user['user_fb_id'];
$totalPoint = $db->resultsArray;
$result[$key]['totalPoints'] = $totalPoint[0]['totalPoints'];
$db->query("SELECT user_firstName, user_lastName FROM user WHERE user_fb_id = '{$user['user_fb_id']}'");
$userDetail = $db->resultsArray;
$result[$key]['user_name'] = $userDetail[0]['user_firstName'].' '.$userDetail[0]['user_lastName'];
}
return $result;
using this function i can get users details. but not in an order. It should be sorted DESC.
How can to write single query for this function, instead of having 3 quires.?
or else,
how to sort the array 'totalPoints'?