$xoopsDB -> queryF( "UPDATE " . $xoopsDB -> prefix( "lxentries" ) . " SET counter = counter+1 WHERE term = '$term' " );
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?