Newbie question about stats

[Keith Warren]

I want to be able to track how many times any particular record is 
returned from a search, and I have two ideas about how to do this. But 
because I have little experience with MySQL, I may be totally off base.

This database is served on the web via Lasso.

Idea 1. Create an integer field in the table that contains the records 
I want to track, and increment this field each time the data is 
displayed.

Idea 2. Create a new table and create a new record in this table each 
time the record that I want to track is accessed.

Is either of these two ideas a reasonable way to accomplish this goal? 
Is there a better way?

Thanks,
Keith Warren
Systems Editor
The Clarion-Ledger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]