Get Row Number in MySQLi

[PCHomepage]

How can I get the row number in a list of entries? It's not the number of rows in the result that I need: it is a line by line count of each one.

 

[ChrisHirst]

MySQL doesn't have 'row numbers' per se, the records returned are simply an array, going from 0 to (count - 1), in whatever sort order was specified in the query.

Chris.

Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.
Webmaster Forum

 

[PCHomepage]

That's what I thought. I'm trying to create a function to provide the row number when run inside a loop so how would I do it? I'm not sure where to begin.

 

[ChrisHirst]

http://php.net/manual/en/control-structures.break.php

the first example code does what you want, all apart from incrementing a counter in an } else { operation

Chris.

Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.
Webmaster Forum

 

[vacunita]

That's what I thought. I'm trying to create a function to provide the row number when run inside a loop so how would I do it? I'm not sure where to begin.

Can you not just add a counter?


For example:

$rowNumber = 1;
while($row=mysqli_fetch_row($result))
{
[indent]echo $rowNumber . $row['fieldname'];[/indent]
$rowNumber++;
}

This will increase $rownumber by one each time a row is echoed out.

Or is there something else you are trying to accomplish?



----------------------------------
Phil AKA Vacunita
----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

Web & Tech

 

[PCHomepage]

Thank you, that is exactly what I was looking for!