cgm225 Posted February 13, 2008 Share Posted February 13, 2008 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! Link to comment https://forums.phpfreaks.com/topic/90970-getting-row-number-of-entry-returned-in-query/ Share on other sites More sharing options...
Orio Posted February 13, 2008 Share Posted February 13, 2008 $i = 1; while($row = mysql_fetch_array($full_image_results)) { $filename = $row['filename']; echo $i." ".$filename; $i++; } Orio. Link to comment https://forums.phpfreaks.com/topic/90970-getting-row-number-of-entry-returned-in-query/#findComment-466229 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.