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]

Reply via email to