2 Posts
5 years ago
3
Topic
Hello Forum
I wrote a database using Seblod data.
These data I would like to count us now output. As a beginning I don't find an approach how to solve this.
Name| date1| date2| date3
Max | yes | no | yes
John | no | yes | no
Peter| yes | yes | no
Now I want to count the number yes in date1. Next the number yes in date2 and also for date3.
This result should then be displayed in the frontent
Totally count:
date1| date2 |date3
2 | 2 |1
For your help I thank you already!
The beginner ;-)
1283 Posts
5 years ago
0
Level 1
sql query could be like this:
SELECT COUNT(date1)FROM #__cck_store_form_mytable;
and put this in field from sql pack, and have it in the list view.
Post your sql query here, maybe someone can halo with that
2 Posts
5 years ago
0
Level 2
Hello Bucklash
I bought the SQL module and it works fine.
Many thanks