Gordon Stewart Wrote:
-------------------------------------------------------
> Peter Brawley Wrote:
> -------------------------------------------------------
>
>
> > I'll have a lash at feeding your requirement
> back
> > to you in language that I can understand ...
> you
> > want to find rows where category='account',
> > specifically the reference values in those
> rows,
> > and list all the other ca.category values where
> > reference=1. Is that it? If not, please
> elaborate.
>
> YES, thats correct - Though i also want the
> title/URL fields too. But i know they will be
> duplicates & can deal with that after.
>
Ive updated
http://irdlinks.kwister.com/test.php
1) if i search for ACCOUNT, I'll gert record number 1 AND record number 3 - as the term ACCOUNT appears in two records.
I'll also get the other records: AGENT, CLOSED, FINANCE and MONEY.
2) If i search for MONEY - that will only get 1 record, and the other two categories - ACCOUNT and FINANCE.