Hi

I'm trying to create some statistics, for example I want to have the number
of the search done today, I wrote this query.
select count(time) from search_history where year(time) = year(curdate())
AND month(time) = month(curdate()) AND DAY(time) = day(curdate());

My problem is... if the user do the login in the opac and then do a search
the table search_history is updated but if the user do a search without
login nothing is written in the database.

Any idea?

--
View this message in context: 
http://koha.1045719.n5.nabble.com/Statistic-with-Koha-tp4622398p4622398.html
Sent from the Koha - Discuss mailing list archive at Nabble.com.
_______________________________________________
Koha mailing list  http://koha-community.org
[email protected]
http://lists.katipo.co.nz/mailman/listinfo/koha

Reply via email to