Please Log in to join the conversation.
Please Log in to join the conversation.
Please Log in to join the conversation.
You'd need to specify a WHERE in your query to `id` = [user_id].So with this solution, I believe I can't isolate the value for just one user. Or not?
Please Log in to join the conversation.
Please Log in to join the conversation.
SELECT ( IF( `cb_groupe1` = 'Archiv', 1, 0 ) + IF( `cb_groupe2` = 'Archiv', 1, 0 ) + IF( `cb_groupe3` = 'Archiv', 1, 0 ) ) FROM `#__comprofiler` WHERE `id` = [user_id]
Please Log in to join the conversation.