This is my current query.
SELECT #__users.name FROM #__users INNER JOIN #__user_usergroup_map ON #__users.id = #__user_usergroup_map.user_id INNER JOIN #__usergroups ON #__usergroups.id = #__user_usergroup_map.group_id WHERE #__usergroups.id = '14'
It pulls all the correct information as needed, It, however will not save what information that is selected. I believe it's because i don't have a 'VALUE AS' statement of some kind. I cannot for the life of me, remember what i'm supposed to add to the query to make this happen.
HI, you need to have text and value aliases in query e.g. SELECT u.name AS text, u.id AS value FROM #__USERS AS u ....
Hey, would you write this for me? Because I´m a noob for this :/
Sorry
@Williwusel
I highly recommend this site for learning MySQL and aliases :
http://www.mysqltutorial.org/mysql-alias/
