22 Jul
2011
22 Jul
'11
11:50 a.m.
Le 22/07/2011 11:27, schwitzd a écrit :
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?
grep search zebra.logs |wc-l should do the trick. -- Henri-Damien LAURENT