> -Original Message-
> From: Nathan Simms [mailto:[EMAIL PROTECTED]
> The problem is that I need my statement to search the
> product_name and
> description fields as well. However when I add them to my
> statement, it
> doesn't work???
> The statment below does not work:
>
> SELE
I am searching for a specific company name that gets passed to this page. I
tried adding the mysql statement:
SELECT product_id, company_name, product_name, url, description
FROM product, company
WHERE product.product_id = company.company_id AND
description LIKE '%FORM.query%' AND
company_name L
On Fri, 22 Aug 2003 23:28:18 +
"Nathan Simms" <[EMAIL PROTECTED]> wrote:
> Hi, I'm currently using the following mysql statement to perform a search.
> Right now it is only returning the results which are found in the
> description field. How do I modify this statement so that it is searching
Hi, I'm currently using the following mysql statement to perform a search.
Right now it is only returning the results which are found in the
description field. How do I modify this statement so that it is searching
the following fields: company_name, product_name, description.
SELECT product_id,
