Quick PHP/MySQL row total question

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
User avatar
waradmin
Forum Contributor
Posts: 240
Joined: Fri Nov 04, 2005 2:57 pm

Quick PHP/MySQL row total question

Post 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.
User avatar
kendall
Forum Regular
Posts: 852
Joined: Tue Jul 30, 2002 10:21 am
Location: Trinidad, West Indies
Contact:

Post 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
Post Reply