View Full Version : How do I record searches done on a database?

03-10-2006, 09:20 AM
Hi there, I am using an Access database with Dreamweaver and ASP. In this database i want to create a column with a number that increases every time someone searches that particular record. Anyone know how I should do this?



03-10-2006, 09:40 AM
add a column to your database

in the recordset SQL that searches the db read the value of the column

after the recordset has read the result add an update statement

then just increment by 1

sorry i cant give you any ASP examples but im a PHP ninja