Hello, im working on an article system and looking to avoid running three queries. example, i have this query: SELECT id,title FROM articles WHERE id=$_GET[id] now say $_GET[id] = 5 I would like to get the previous id 4 and the next id 6 (if there is one) so i can do something like: << Previous Article [Title] Next Article [Ttitle] >> i would assume this is impossible without running mulitple queries? just thought i'd ask in case i am wrong. i am using mysql 4x thanks -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
