Getting to row number

[Matthew Reynolds]

Hiya all

I'm just wondering if there's a way to returning the row number of a particular row based from a WHERE clause.

So if I were to do a "SELECT * FROM dbname WHERE id='foo'" how can I find out what row number it is using a different SQL query? Or maybe a PHP function?

Thanks!
Matt