On Sat, 19 Jan 2002, Chris Payne wrote:

> Hi there,
> 
> I made some of the changes you said below, and when I check the query I get
> this:
> 
> The query is SELECT distinct description, email, url, country, category,
> type, rating from search6 WHERE description LIKE '%word%'AND category =
> 'Automotive' AND country = 'Austria' AND type = 'Car Rental' ORDER BY
> description
> 
> 
> so to me it doesn't appear to be putting the array item in there, or am I
> wrong?  I am confused, thanks for your help.
> 
> > You should probably be using:
> >
> >   $sql .= " description LIKE '%word%' OR "; # note the spaces


Missed this error the first time round. It should be:

  $sql .= " description LIKE '%$word%' OR "; # note the $!!


hth
-- 
Jason Wong


-- 
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