search for: elisfanclub

so here is the deal. i''ve got three tables: lists, items, comments, and this is how they are laid out: lists table id title items table id list_id item comments table id list_id comment to give you some background. in order to get a list of all the lists i am making this call: SELECT lists.id, title, count(items.list_id) AS total_list_items FROM lists INNER JOIN

i know that title sounds confusing, but here is the deal: the two columns that we are concerned with for this question are the "updated_on" column and the "views" column. the views column increases everytime a user visits a certain page. like this: @object.update_attributes(:views => @object.views + 1) the problem is that when a user visits the page, it AUTOMATICALLY