On Monday 28 January 2002 21:05, Markus Lervik wrote:
> 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.Huom
>autuksia 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.
Crikey, it looks terribly complicated for what looks like something to page
through a set of results.
Wouldn't it be easier to do away with the ereg_replace()?
if($go=="next") {
if($page < $nr_pages && $page >= 0) {
$page++;
$start = $page * 20;
}
}
$qry = "SELECT
L.Tunnus,N.Nimi,L.ISSN,L.Vuosi,L.Lis�tietoja,L.Vuosikerta,L.Numerot,L.Huom
autuksia FROM uusi_lehtitaulu L, nimet N
WHERE (L.Nimi_id=N.id AND N.Nimi LIKE "asdf")
LIMIT $start,20"
Even it this doesn't work, at least it's easier to understand :)
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
/*
The way to love anything is to realize that it might be lost.
*/
--
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]
