On Monday 28 January 2002 17:34, Jason Wong wrote: > > 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 :)
Well, in this particular case it won't work at all, because the SQL-query is dynamically created based on what the user wants to search for. It doesn't nessecary include all columns. The only static bit of the query is "FROM uusi_lehtitaulu L, nimet N" and "WHERE (L.Nimi_id=N.id" : ) It would be just as big a mess with a truckload of concatenations, like $query = "SELECT " . $tables . " FROM uusi_lehtitaulu L, nimet N WHERE (L.nimi_id=N.id" . $search . ") LIMIT $start,20"; Besides, I have a strange fetisch to do everything the hard way. : ) 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]