[RESOLVED] current row number

[autocolismo]

i'm working an image gallery.
When we click a thumbnail we can see the foto with bigger dimensions. And the idea is creating navigation buttons there (previous - next).
For that in the new page i need a new query, all i have is the active image ID.
So who do i make the new query?
something like:
"SELECT * FROM TABLE LIMIT $id, 1"
doesn't work, because the id is not the row number.
Is there a way to find the exact row number of a record in a certain query????
😕

[frost110]

mysql_num_rows($query_result);

Will give you number of rows returned by a query.

What you will need to have is get data. So the url would be
http://www.yoursite.com/imagegallery.php?page=2&results=10

This means page 2 with 10 results per page. With that you can calculate how many to select the next go round:

<?
     $start = $_POST['results'] * $_POST['pg'];
     $howmany = $_POST['results'];
     $query_result = mysql_query("SELECT * FROM TABLE LIMIT ".$start.", ".$howmany . " ORDER BY name desc");

// Do rest of row processing for display.
?>

--FrosT

[autocolismo]

Thanks for your post.
I managed it.
Something like you posted, but i think that i couldn't get the selected record with that, so i got something like this:

#to keep incrementing $y when navitating the pages
if(!$y){$y=0;}

do {
$y++;
echo $row_fotos['foto'];
}while($row_fotos = mysql_fetch_assoc($fotos));

when get to page 2:
page.php?foto=<?php echo $y;?>

at the second page i make the same query but the LIMIT is:

LIMIT $y, 1

then i have what i want and ready no navigate next and previous records 😃

[frost110]

Well glad I could help.

--FrosT