inal Message-
From: Rus [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 31, 2001 2:11 AM
To: [EMAIL PROTECTED]
Subject: Re: AND on a many to many table, with arbitrary ANDs
I think you could use 'WHERE catid IN'
For example, on PHP
$catlist="1,2,3,4,5";
... select ... wher
I think you could use 'WHERE catid IN'
For example, on PHP
$catlist="1,2,3,4,5";
... select ... where ... catid in ($catlist)
And of course you should use category id in web form instead category name.
- Original Message -
From: Beasley, Julien <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]
Julien
What you're trying to do isn't that uncommon, and I've met the same
problems in two major systems that I've built over the last year.
My solution was to use SQL up to a point (i.e. limit the complexity
of the query) to protect the performance of the server. So, for example,
you can read e
if my understanding is correct just have two joins using ors for the
categories :-)
On Tue, 30 Jan 2001, Beasley, Julien wrote:
> Hello everyone,
>
> I am in the process of building a search engine on a database. I have two
> tables that have a many-to-many relationship: A story table and a cat