Page 1 of 1

Quick PHP/MySQL row total question

Posted: Wed Sep 27, 2006 2:48 pm
by waradmin
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.

Posted: Wed Sep 27, 2006 3:32 pm
by kendall
Think you want to do some pagination? do a google for pagination techniques...probably even in this forum i'm sure you will be able to understand what to do from there


Kendall