Hi, yeap... typo... :-( sorry about that..
$d_did=dept3['did']; should be $d_did=$dept3['did']; Emir > Hi, > > ehem, I have to withdraw the post below :) The sql query is ok. it works > in > my local installation. the problem was caused by some typo bugs. I will > report on it later. > > Nice work Emir !!!! > > Elpidio > > On Wednesday 08 December 2004 21:58, Elpidio Latorilla wrote: > > Hi Emir, > > > > it looks like you are using the mysql 4.1 version because of your use of > > cascaded "select" in your query. Earlier versions of mysql do not > support > > this. I cannot run the script because of my older mysql version. > > > > Well, looking at the query, it looks like it can be rewritten to one > using > > only normal joins. > > > > Let me see.... > > > > Elpidio > > > > ------------------------------------------------------- > SF email is sponsored by - The IT Product Guide > Read honest & candid reviews on hundreds of IT Products from real users. > Discover which products truly live up to the hype. Start reading now. > http://productguide.itmanagersjournal.com/ > _______________________________________________ > Care2002-developers mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/care2002-developers > -- NEU +++ DSL Komplett von GMX +++ http://www.gmx.net/de/go/dsl GMX DSL-Netzanschluss + Tarif zum superg�nstigen Komplett-Preis! ------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://productguide.itmanagersjournal.com/ _______________________________________________ Care2002-developers mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/care2002-developers

