On Monday 28 January 2002 23:45, Markus Lervik wrote:
> 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";
I usually give the concatenations a miss if I can and just use:
$query = "SELECT $tables FROM ... ";
> Besides, I have a strange fetisch to do everything the hard way. : )
Masochist :)
Anyway, as per the subject, how are you getting $page? I assume it is stored
in the session. Is $page behaving correctly when you go from one page to the
next? Could you post the relevant code?
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
/*
Distrust all those who love you extremely upon a very slight acquaintance
and without any visible reason.
-- Lord Chesterfield
*/
--
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]
