Re: mysql query
| From: | Stephen Johnson | Date: | Fri, 18 Feb 2005 01:05:09 +0000 |
| Subject: | Re: mysql query | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-208980@lists.php.net to get a copy of this message | ||
Now I am assuming that 4 and 6 would not always be the next article ID -
otherwise you could just increment your id accordingly.
If you wanted to do that without running multiple queries, this is who I
might do it, rather sloppy, but I think it would work.
$idGet= $_GET['id'];
$sql = "select id, title from articles";
$db->query($sql);
$i=0;
while($db->getRow()) {
$id[$i] = $db->row['id'];
$title[$i] = $db->row['title'];
$i++;
if($id[$i] == $idGet) {
$j = $I;
}
}
$prev = $j-1;
$next = $j+1;
<<previous $title[$prev ]
next $title[$next] >>
<?php
/*
Stephen Johnson c|eh
The Lone Coder
http://www.thelonecoder.com
stephen@thelonecoder.com
562.924.4454 (office)
562.924.4075 (fax)
continuing the struggle against bad code
*/
?>
> From: "Sebastian" <sebastian@broadbandgaming.net>
> Date: Thu, 17 Feb 2005 19:24:50 -0500
> To: <php-general@lists.php.net>
> Subject: [PHP] mysql query
>
> 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