LoRz

SELECT *, 1 as NextRec
FROM models
INNER JOIN
(
SELECT models.mod_id FROM models INNER JOIN (SELECT mod_id FROM models WHERE mod_id = 1 ) as info ON models.mod_id > info.mod_id ORDER BY models.mod_id LIMIT 1
) as nextrec ON nextrec.mod_id = models.mod_id
UNION ALL
SELECT *, 0 as NextRec
FROM models
INNER JOIN
(
SELECT models.mod_id FROM models INNER JOIN (SELECT mod_id FROM models WHERE mod_id = 1 ) as info ON models.mod_id < info.mod_id ORDER BY models.mod_id DESC LIMIT 1
) as prevrec ON prevrec.mod_id = models.mod_id

posted by Lorz  # 4:34 AM