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