mysql help

[eluser]xzela[/eluser]
Hi,
What are the benefits of performing this action within SQL?
To solve this problem you can try a subquery. It may or may not work:

Code:

SELECT
  (SELECT COUNT(*) FROM table WHERE something = something_else) + 1 AS position
FROM
  another_table
WHERE
  column = something