|
|
Posted by Bret Hughes on 02/18/05 03:28
On Thu, 2005-02-17 at 18:24, Sebastian wrote:
> 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:
>
sure how about :
select id, title
from articles
where id >= $_GET[id] - 1
and id <= $_GET[id] + 1
order by num;
should be valid sql but I have no experience with mysql
Bret
Navigation:
[Reply to this message]
|