PDA

View Full Version : Current Row Number


acid
03-22-2006, 12:20 AM
Is there a way to tell the current photo's position out of the total number of photos posted? (e.g. # 23/123 photos). the closest thing i could find is mysql_row_tell() to return the value of the current row.

just a thought.

GeoS
03-22-2006, 09:12 AM
It is possible but need additional query and loop - it will slow down more Pixelpost.

Joe[y]
03-22-2006, 12:13 PM
you could just do this in a template using tags very easily:


#<IMAGE_ID>/<SITE_PHOTONUMBER>

acid
03-22-2006, 10:07 PM
']you could just do this in a template using tags very easily:


#<IMAGE_ID>/<SITE_PHOTONUMBER>

you can't do that though, because the <IMAGE_ID> does not correspond to the row number (i.e. the position out of the total image numbers sorted by date). in most cases, entries are deleted and the image_id will not be replaced, instead the number continues to increase. thus, IMAGE_ID will surely be larger than SITE_PHOTONUMBER

Joe[y]
03-23-2006, 04:02 PM
ah. i didn't think of it like that. my image ids still represent an accurate represantation of row number but i see what you mean by some people possibly deleting posts.