Hi guys, I have this basic table
id_image int unsigned PK
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.