On Monday 28 January 2002 14:57, Jason Wong wrote:
> > Somehow when I print the value of $query, it looks fine.
> > Then, when I change $query a bit and print it again,
> > it looks fine.
> > Change it a third time, and it suddenly gets the value it
> > had in the beginning.
> Could you post some code please?
Well, for instance, this screws up the $query. It works if one clicks
once on the next-button, but clicking another time resets the query to
SELECT
L.Tunnus,N.Nimi,L.ISSN,L.Vuosi,L.Lisätietoja,L.Vuosikerta,L.Numerot,L.Huomautuksia
FROM uusi_lehtitaulu L, nimet N
WHERE (L.Nimi_id=N.id AND N.Nimi LIKE "asdf")
LIMIT 0,20
if($go=="next") {
if($page < $nr_pages && $page >= 0) {
$page++;
$replace_with= (($page) * 20).",";
echo "replace_with: " . $replace_with;
$replace = (($page-1) * 20).",";
echo "replace: " .$replace;
$query=ereg_replace($replace,$replace_with,$query);
}
}
It's the LIMIT 0,20 -> LIMIT 20,20 -> LIMIT 40,20 that doesn't work. Strange thing is,
that
it worked about a week ago. : \
I can't really recall changing that part of the code at all at that point.
Cheers,
Markus
--
Markus Lervik
Linux-administrator with a kungfoo grip
Vaasa City Library - Regional Library
[EMAIL PROTECTED]
+358-6-325 3589 / +358-40-832 6709
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
