I have marked a column “index” in a table “count” every time I visit the website with a “1”.
I would like the SQL statement that would add up all the "1"s and give the site counter a value.
There are some blank spaces where other websites with different columns in table “count” were recorded.
I tried:
“SELECT SUM(index) FROM count;”
but this yielded the blank cell.