Calculate position based on a value

hi guy girl,

watch your error

SELECT a1.from_user_id, a1.total_stats, COUNT(a2.total_stats) position
FROM score a1, score a2
VS
$this->db->select('a1.from_user_id, a1.total_stats, COUNT(a2.total_stats) position');
$this->db->from('score');

try to do this

$this->db->from('score a1, score a2');

but i didn't understand why you used 2 aliases for the same Table ?

can't you do this ?

SELECT from_user_id, total_stats, COUNT(total_stats) AS position
FROM score
WHERE total_stats <= position AND from_user_id=25030
GROUP BY from_user_id, total_stats
ORDER BY total_stats DESC, from_user_id DESC