That only gave me 1 result. So I must be leaving out something important.
The hits table has multiple entries for each page and I am trying to count them and include the result for each page.
I want to get an output like:
pagenum pagedescription hits
4567 Pagetext... 456
4568 anotherPagetext 435
The hits table looks like this:
Not sure if it maters but I am also doing a join from another table like:
JOIN users on users.AccountNum = pages.ActNum
Thanks a TON!