Image Retrieval

[Anon]

Please forgive me if you've seen this in Coding Help, I meant for it to go in here....

Hi,

I've got a bit of an issue that I'm not sure about. I've written an image loading program that loads one image at a time. On a click of a 'next' link it calls itself adding 1 to the key value and therefore retrieving the next image in the D/B. The key value used is just an integer (mysql auto_incremented).

The code works fine but I want the user to be able to delete records - if this happens then my logic falls down because it relies on sequential integer keys.

Can anyone suggest an alternative approach?

Thanks in advance.

Chris

[Anon]

Chris,

It's simply(ish) a matter of changing the way that your next key works. You could do a select right at the begining and load all the sequential keys into an array. Then when the users presses next, you increment one through the array keys, resulting in the real ID value in your next select statement.

or:

Do a second read along the lines of :

select id from my_tab where id > (current_id) limit 0;

and store the id returned (which will be the next ID needed) into a variable which the next button uses.

Cheers
Justin