I have a lexikon module installed with lots of entries there. Each entry has a counter to calculate how many times it was shown on the user side.



I want to create a 'Word of the day' block to show the most popular entry today (the entry that was shown the most times for the latest 24 hours). Any ideas how to do this?

Regards,

Deka

Hi deka,

You need to create a table that counts the id of the word and the unix timestamp of the hit. Then you also need to drop the table records when the unixtimestamp is more than 48 hours old otherwise you will end up with a huge table.

Once you have done that you need to do a select a bit like:



This will return the number of hits it has from largest to smallest with the id of the item. 13000000 has to equal 24 hours ago in unixtime which would be something like:

thanks wishcraft. i believe this will work