[SOLVED] multicheckbox + counter
krileon
13 years 3 months ago #149770
by ubertramp
Replied by ubertramp on topic Re:multicheckbox + counter
Ive checked out this thread (and this particular post) but i cant see the solution on there. 
Ive now added to the thread with my question on how you managed to do it, so i wont double post it here, but this is also EXACTLY what i am also trying to achieve for my site members ie. im also looking for a way that i can count up the amount of checkboxes that have been checked in a multi checkbox cb field (and once counted i can then out put it as a number)
i can list the outputs, as in print onscreen the actual names that have been checked, but i really would love to be able to present it as a figure ie user xx has xx out of xx boxes checked.
any help, pointers or tips would be VERY MUCH appreciated. Many thanks!!
Ive now added to the thread with my question on how you managed to do it, so i wont double post it here, but this is also EXACTLY what i am also trying to achieve for my site members ie. im also looking for a way that i can count up the amount of checkboxes that have been checked in a multi checkbox cb field (and once counted i can then out put it as a number)
i can list the outputs, as in print onscreen the actual names that have been checked, but i really would love to be able to present it as a figure ie user xx has xx out of xx boxes checked.
any help, pointers or tips would be VERY MUCH appreciated. Many thanks!!
Please Log in to join the conversation.
13 years 3 months ago #149817
by ubertramp
Replied by ubertramp on topic Re:multicheckbox + counter
Hi Kyle,
Many thanks for the swift reply and your time in helping us out on this one.
If i can get site sponsorship then subs is something that i will be snapping up soonest. As it is at the mo though, itll cost me more than i can afford with 1000's of members
anyway, thats another subject!
Your query is something very similar to that which i am working on using the MySQL Field Type Plugin at the mo.
currently i have
SELECT LENGTH(cb_field1) - LENGTH(REPLACE(cb_field1, '|*|', '@@')) + 1
FROM #__comprofiler
WHERE user_id = {USERID}
...it counts the dividers (|*|)and adds '1' to the figure. This is all fine and dandy unless there are no boxes checked, in which case you can see it adds a 1 to the non existent number.
thanks again for your help and suggestions, its warming to know that i am barking up the RIGHT tree for once!!
if i have any more breakthroughs or find other ways to get the same result ill add to this thread.
cheers
Many thanks for the swift reply and your time in helping us out on this one.
If i can get site sponsorship then subs is something that i will be snapping up soonest. As it is at the mo though, itll cost me more than i can afford with 1000's of members
anyway, thats another subject!
Your query is something very similar to that which i am working on using the MySQL Field Type Plugin at the mo.
currently i have
SELECT LENGTH(cb_field1) - LENGTH(REPLACE(cb_field1, '|*|', '@@')) + 1
FROM #__comprofiler
WHERE user_id = {USERID}
...it counts the dividers (|*|)and adds '1' to the figure. This is all fine and dandy unless there are no boxes checked, in which case you can see it adds a 1 to the non existent number.
thanks again for your help and suggestions, its warming to know that i am barking up the RIGHT tree for once!!
if i have any more breakthroughs or find other ways to get the same result ill add to this thread.
cheers
Please Log in to join the conversation.
Moderators: beat, nant, krileon
Time to create page: 0.229 seconds
