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]