Угу) А можно еще доработать...

Dims 03.05.2008 14:04

SELECT n FROM 
       (SELECT id, @n:=@n+1 AS n 
        FROM object 
        WHERE parent_id = $parent_id AND is_published = 1
        ORDER BY sort_order) as tmp
WHERE id=$iMyId