List:General Discussion« Previous MessageNext Message »
From:Martin Ramsch Date:August 17 1999 1:53pm
Subject:Re: complicated query
View as plain text  
Hi, I just wrote:
> Randy, next time please state clearly the programming language used.

Sorry, I overlooked your first line:
| [...] building a dating website with mysql and php3 [...]

A small correction to my last email:
>  b) SELECT h.memberid
>     FROM   datinghavetags AS h
>          , datingwanttags AS w
>     WHERE  h.tagid    = w.tagid
>       AND  h.tagvalue = w.tagvalue
>     GROUP BY h.memberid
>     HAVING COUNT(*)=$num;
>       --> store resulting list of memberids

I forgot about taking the desired w.memberid into account!
So please add:
         AND w.memberid=4711;

Hopefully it's okay now. (Well, I doubt it, because untested ...:)

Martin Ramsch <m.ramsch@stripped> <URL: >
PGP KeyID=0xE8EF4F75 FiPr=52 44 5E F3 B0 B1 38 26  E4 EC 80 58 7B 31 3A D7
complicated queryRandy Gerritse17 Aug
  • Re: complicated queryMartin Ramsch17 Aug
    • Re: complicated queryMartin Ramsch17 Aug
      • RE: complicated queryRandy Gerritse17 Aug