Jump to content

Getting row number of entry returned in query..


cgm225

Recommended Posts

I have a mysql query as such:

    $query = "SELECT * FROM images WHERE album = $album_id ORDER BY filename ASC";
    $full_image_results = mysql_query($query);

 

and then I echo the results like so:

    while($row = mysql_fetch_array($full_image_results)) {
        $filename = $row['filename'];
        echo $filename;
    }

 

What additional statement can I put within the While statement to also echo the number of the row the entry was found within the query.  Restated, I do NOT mean the entry/row id value, I mean if the query returned 30 results, and a particular entry was the 28th returned entry, how would I echo "28"?

 

Thank you all in advance!

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.