Hi ,
I need report to get the totalhits date and course vise.
SELECT COUNT(l.id) hits, l.course courseId, c.fullname coursename
FROM mdl_log l INNER JOIN mdl_course c ON l.course = c.id
GROUP BY courseId
ORDER BY hits DESC
This gives me output like this
It gives me the total hits . But need date wise.
Any Solution.
Thanks in advance