Getting the row number

[HalfLife]

Let's say I have $id, I want to get the row number where id='$id', how do I do it?

[ahundiak]

Yan can define a column called row_num and make sure it get's set when the record is created or updated.

But that's probably not what you want. You want some kind of 'natural' row number which is automatically kept up as records are deleted. Alas, such a thing does not exist. Rows are stored in whatever order the database wants to.