[mdhall]

Is there any way to count, and display, the number of times a row has been accessed? For example, you have a site with book reviews, and a basic search brings up a results page, with several listings for an author, title, and "More Info" link. The user clicks the link to view more info on that book. By clicking that link, they are taken to another page that displays the entire table row for that book, to see more information. What I need is something to track how many times that link is clicked to basically display something like a "Most Popular" page, which counts how many times each row is viewed and displays the rows (book listings) with the most views. Will a standard link counter work, or is there a better way within mysql to track and display something like this? Maybe a count field in each row that auto-increments with each view?

[NeverMind]

add a column called 'counter' for example and all you need is to add an UPDATE statment in the book display page which will bring the counter value and add 1 to it .. then you could call the counter value in any page you want ..
basicly something like that would work :

PHP Code:

mysql_query("UPDATE table1 SET counter=counter+1 WHERE book='$book'")or

die(mysql_error()); 

[mdhall]

So when the second display page is brought up, that page needs the count query included into it, which will update the count field. Sounds easy enough, thnx.