Hi guys I have a table that I want to use to queue singers.
the table is called queue what I need to happen when I press a button on my page is to go through the table q find the smallest id and update to 1 greater the the largest id but I can't seem to get the syntax right ...tried many ways but am stuck. The id field auto increments.
thanks in advance for any advice
UPDATE `queue` SET `id` = MAX(id) + 1 WHERE `id` = MIN(id);