Re: Auth and joins

From:	Gerard Bowe	Date:	Tue, 15 Nov 2005 11:36:44 +0000
Subject:	Re: Auth and joins
References:	1 2	Groups:	php.pear.general
Request:	Send a blank email to pear-general+get-21930@lists.php.net to get a copy of this message

Justin Patrin wrote:

On 11/14/05, Gerard Bowe <gerard.bowe@jrc.it> wrote:
Is it possible to do a join with the Auth package (or send raw sql). I have three tables Users, Groups and UserGroups (a user may belong to one or more groups). I would like to get the group(s) when the user logs in and and register them in the SESSION.
I believe you can set the SQL in the config array... -- Justin Patrin

Can you explain haw this is done? The only options that I can set are (or is there a way to set config data); $params = array(

            "dsn" => "",
            "table" => "",
            "usernamecol" => "",
            "passwordcol" => "",
            "db_fields" => "",
            "cryptType" => ""
            );

$a = new Auth("DB", $params); Thanks ger