Darkness Soul Posted April 6, 2006 Share Posted April 6, 2006 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_flagI verify the login/pass in [user_data], so, I start to record the session. I record:* usr_name* usr_id* usr_group* usr_flagMy 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 idFROM( 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. Link to comment https://forums.phpfreaks.com/topic/6734-inner-join/ Share on other sites More sharing options...
Darkness Soul Posted April 6, 2006 Author Share Posted April 6, 2006 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.idFROM( user_group INNER JOIN user_flag ON user_group.id = user_flag.idgrupo)INNER JOIN user_dataON( user_flag.id = user_data.id)AND( user_group.id = user_data.id_grupo)WHERE user_data.id = '. $int_id .'LIMIT 1 ';[/code] Link to comment https://forums.phpfreaks.com/topic/6734-inner-join/#findComment-24479 Share on other sites More sharing options...
wickning1 Posted April 6, 2006 Share Posted April 6, 2006 [code]$sql = 'SELECT f.id FROM user_flag fINNER JOIN user_data d ON d.id_group=f.id_groupWHERE d.id = '.$int_id;[/code]Sounds a lot easier than what your code is doing. Am I missing something? Link to comment https://forums.phpfreaks.com/topic/6734-inner-join/#findComment-24493 Share on other sites More sharing options...
Darkness Soul Posted April 6, 2006 Author Share Posted April 6, 2006 Yeah, sounds a lot easier than mine..=) Thank you! I'm testing but think is all here.And its work well =D thanks Link to comment https://forums.phpfreaks.com/topic/6734-inner-join/#findComment-24509 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.