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 ...:)

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