Quick PHP/MySQL row total question
Posted: Wed Sep 27, 2006 2:48 pm
Alright so I have total row's in a table called pictures set as $row_count (using $row_count = mysql_num_rows($result);).
Now, I want to be able to say Picture ___ of ___ where of___ is obviously $row_count, but how would I go about getting the first ___?
In the address bar the following information is set, viewphoto.php?id=######&album=#&photo=&&&&&
id is the row global_id (the row that ties it to the user's account), album is the album id the picture is coming from, and photo is the auto_inc id of the picture.
Any ideas on how to figure out which image of the total it is showing?
Thanks.
Now, I want to be able to say Picture ___ of ___ where of___ is obviously $row_count, but how would I go about getting the first ___?
In the address bar the following information is set, viewphoto.php?id=######&album=#&photo=&&&&&
id is the row global_id (the row that ties it to the user's account), album is the album id the picture is coming from, and photo is the auto_inc id of the picture.
Any ideas on how to figure out which image of the total it is showing?
Thanks.