image retrieval

[Anon]

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]

I would read all the data into an array, count the array to handle your next/previous buttons. Then reference each image's id_number from the array to delete it.