Stepping through auto-increments one at a time?

[Dean C]

Hmm make an intermediate table:

fimage:
- imageid
- datepicked

When you pick an image, insert it's id and dateline in there. Then on your homepage just have something like:

SELECT 
        imageid
FROM 
        fimage 
WHERE
        DATEDIFF(current_date, dateline) = 1
LIMIT 
       5

Untested ^^