MySQL jump rows

[gerkintrigg]

Hi. I'm trying to make a script that displays one image from a database at a time.

These images should be displayed sequentially and ordered by the id field.

I don't want to get ALL images and use a script to change the image as that'd take too much time and effort from the server, so I wrote a script to get the highest and lowest values and then just get the next highest value up from a random one I generated.

That bit works fine.

My question is:
When I get to the end of the database, I need to flip it back to the first record, but keep getting this:
[code]Warning: mysql_result(): Unable to jump to row 0 on MySQL result index 13 in /hsphere/local/home/davetrig/neil.magic2k.com/pigs/members/random_pig.php on line 47[/code]

Is there an easy way to do this as my code seems to be getting bigger!

Thanks,
Neil