function getRankArray() { $data = new DataAccess('photo'); $sql = "SELECT place_id, vote_count FROM places ORDER BY vote_count DESC"; $resultset = $data->getResultSet($sql); $i = 0; $v = -1; $placeID = array(); $rank = array(); while ($row = $data->getRow($resultset)) { if ($v != $row['vote_count']) { $i++; $v = $row['vote_count']; } array_push($placeID, $row['place_id']); array_push($rank, $i); } $data->dispose(); return array_combine($placeID, $rank); }