In (most) SQL servers there is no concept of 'row number'. Most DA's design
tables with a unique primary key. This can be used to identify the row form
all of the other rows but it is not the same as a 'row number'.
Since you are using PHP you can set a counter to 1 before your loop and then
increment it at each loop. This will give you the semblance of a row number
but be aware it is not the same. These are row numbers within the cursor
you are looking at. If your cursor is a subset of the table's data then the
numbers you are counting do not correspond to the data in the table.
HTH,
=C=
*
* Cal Evans
* The Virtual CIO
* http://www.calevans.com
*
-Original Message-
From: Beeman [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, September 18, 2002 8:30 AM
To: php
Subject: [PHP] MySQL Current Row??
What function/array index should I use to determine the current row of a
MySQL query when outputting using a do..while.. Loop?
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
