26, 2002 2:36 AM
To: <[EMAIL PROTECTED]>
Subject: Re: Trapping for no user input in a query
G'day Ron, all
> Tailor your query to the request of your user(s).
> if ($param1)
> $sql .= "(ad_copy) against ('$param1')";
> if ($param1 && $param2)
G'day Ron, all
> Tailor your query to the request of your user(s).
> if ($param1)
> $sql .= "(ad_copy) against ('$param1')";
> if ($param1 && $param2)
Thank you for your reply. If at all possible though, I'd like to do it from
the mysql side rather than the php side of things.
Is there su
y, March 25, 2002 10:47 PM
To: <[EMAIL PROTECTED]>
Subject: Trapping for no user input in a query
Hello all
I am trying to query two columns in mysql which have fulltext indexes
using the following:
SELECT ID,publication,run_date,left(ad_copy,40) as Advertisement FROM
classifieds WH
Hello all
I am trying to query two columns in mysql which have fulltext indexes using
the following:
SELECT ID,publication,run_date,left(ad_copy,40) as Advertisement FROM
classifieds WHERE MATCH (long_group) against ('\"$param2\"') AND MATCH
(ad_copy) against ('\"$param1\"')
As you can probably
