Selecting from either side of an id

[Derokorian]

Hi guys, I have this basic table
id_image int unsigned PK
image_file varchar(50)
image_ext varchar(5)
image_upload_date datetime
gallery_type tinyint unsigned

What I'm having problems with is selecting 3 images before and 3 images after a given ID. Considering the ids aren't necessarily all inclusive and I may have to narrow the results (IE images from a given month, or of a given type). Any ideas would be greatly appreciated.

[Derokorian]

(SELECT * FROM dev_images WHERE id_image>? ORDER BY image_upload_date ASC LIMIT 3)
   UNION
(SELECT * FROM dev_images WHERE id_image<? ORDER BY image_upload_date DESC LIMIT 3)
   UNION
(SELECT * FROM dev_images WHERE id_image=?)
   ORDER BY id_image ASC

This is what I ended up with, seems to work exactly as wanted (making a filmstrip around the currently views image). Hope this helps someone.

[eval(BadCode)]

SELECT dev_images.* 
FROM dev_images

WHERE id_image >= (?#?)-3
AND id_image < (?#?)+3

ORDER BY id_image ASC

Maybe that's what you wanted? The UNIONS are a bit odd, I would try and avoid them if an alternative exists where you can put the constraints into the WHERE clause.