Row number in mysql tables

[el_quijote]

Is there a way to get the absolute row position of each record in a mysql table. I'm trying to set a scrolling routine based on this ... I already have one based on an autonumber column but becomes unstable when there has been deletions on the table.

Thanks ..

[dalecosp]

I'm not instantly aware of a way to do exactly what you ask --- one could certainly use [man]mysql_num_rows/man to grab the total number of results from a query, then set a counter; that would be pretty common, I'd think.

The idea seems intriguing, and if there isn't, it might be nice to have; but, right now, it's Saturday night, kinda late, and I can't even begin to think of what problems might be inherent in trying to create such a function....

[mrhappiness]

why don't you do your scrolling (hint: some people call it pagination...) like all the other people?

1. count all displayabale results

2. calculate which entries to display (1 - 10, 11 - 20, 21 - 30, ...)

3. SELECT those entries with the use of ORDER BY the_column_you_wanna_order_by and LIMIT (LIMIT 0, 10 for entries 1 - 10, LIMIT 10, 10 for entries 11 - 20, LIMIT 20, 10 for entries 21 - 30, ...)

4. in the loop iterating through the entries returned use a counter

   $counter = 0;
   while ($row = mysql_fetch_assoc($result)) {
     $counter++;
     //some more code
   }

[el_quijote]

Thanks ...

Nice quotation you got there...