Jump to content

Archived

This topic is now archived and is closed to further replies.

Darkness Soul

Inner Join

Recommended Posts

Hi guys,

When the user login, my auth-code save some information in a session, one of these information is the user flag.

I have 3 tables:
* user_data
* user_group
* user_flag

I verify the login/pass in [user_data], so, I start to record the session. I record:

* usr_name
* usr_id
* usr_group
* usr_flag

My problem is with the flag.. A flag just have a group_id with it. So, i was using a INNER JOIN to retrieve this flag_id, but not so happy, something was wrong.

My code:

[code]    $str_sql = '
SELECT
    user_flag.id AS id
FROM
(
    user_flag
    INNER JOIN
    (
        user_group
        INNER JOIN
            user_data
        ON
            user_group.id = user_data.id_group
    )
    ON
        user_flag.id_group = user_group.id
)
WHERE
    user_data.id = '. $int_id .'
LIMIT
    1
    ';[/code]
So, if someone know what I do wrong, I will be greatful, I'm new in mysql.. ^^"!

Bye.

Share this post


Link to post
Share on other sites
I've tried to built it on MS Access, and it give me this code, but still don't working..

[code]        $str_sql        = '
SELECT
    user_flag.id
FROM
(
    user_group
    INNER JOIN
        user_flag
    ON
        user_group.id = user_flag.idgrupo
)
INNER JOIN
    user_data
ON
(
    user_flag.id = user_data.id
)
AND
(
    user_group.id = user_data.id_grupo
)
WHERE
    user_data.id = '. $int_id .'
LIMIT
    1
        ';[/code]

Share this post


Link to post
Share on other sites
[code]$sql = 'SELECT f.id FROM user_flag f
INNER JOIN user_data d ON d.id_group=f.id_group
WHERE d.id = '.$int_id;[/code]

Sounds a lot easier than what your code is doing. Am I missing something?

Share this post


Link to post
Share on other sites
Yeah, sounds a lot easier than mine..

=) Thank you! I'm testing but think is all here.

And its work well =D thanks

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.