hi. I have a database table like that in the attached file. I want count number of database rows. if in sql may look something like this, SELECT count (KotaPenerima) FROM `student` WHERE KotaPenerima = 'Jawa Barat'. How do I put this function, and if I want to display query results on the front page.
Hi devlin .. thanks for your quick response.
it's work, Thank you very much.
I'm still a newbie in using SilverStripe.
but I found another problem, I would like the 'KotaPenerima' a variable that contains all of the 'KotaPenerima, not just 'JawaBarat'. may be an array, I do not know what to put where the array functions?
so that I can display the count of each 'KotaPenerima'.