I'm a real newbie here, so please forgive me if this is a stupid question.
I'm putting a 'Gallery' table together for my gallery in phpmyadmin.
My first field of seven is image_ID. It is set as a primary key with auto increment. The other fields are image_Description, thumb_URL, hires_URL etc..
I've entered thirty entries so far, and have now decided that I want to put a new entry in after image_ID 23
, shifting the existing 24-30
up one(Does that make sense?).
If I try to insert an entry I get the duplicate entry error, which is understandable, but I cannot figure out a way around this.
In the structure options, under 'Add new fields' there's the option to add a field 'After ....', is there not a way of doing something similar for rows in tables. Maybe in SQL.
As it is a gallery, there will be new images created and I will need to swap the order around from time to time, so finding a solution to this, would be very helpful. My goal in the end is to put together a CMS to handle this, but I would like to figure something out at this stage.
Thank you in advance for any help.