MySQL database record hits counter?

[nrepros]

Can I find out how many times a record from the MySQL databse was called and displayed on a web browser?

Basically a MySQL database record hits counter. I’m using PHP/MySQL.

[jeremyluby · Accepted solution]

If you store the data about how many times a record is viewed then yes you can see it.

[nrepros]

--> If you store the data about how many times a record is viewed then yes you can see it.

How is the data stored?

[bregent]

You need to include an update recordset that gets executed everytime another recordset that you want to count fires.

[nrepros]

Ok I have created a Master Detail Page Wizard and it works fine. Now I want to be able to count the hits for a specific record. Using Dreamweaver CS3 how would I include an update recordset to the two files that were created with the Master Detail Page Wizard that gets executed everytime another recordset that I want to count fires?

[bregent]

You would need to build logic that would test the result set to see if it matched the specific records, and then execute the update statement accordingly.

>to the two files that were created

Two files?

[nrepros]

>to the two files that were created

>Two files?

Yes 2 files. In Dreamweaver CS3 & CS4 When using the "Insertà Data Objectsà Master Detail Page Set" function you must create two files:

1. results.php
2. detail.php

It appears that these two files work together hand in hand. You did not specify where nor how to include an update record set that gets executed every time another record set that I want to count fires. So I combined the two as one until it was clarified.

[Guest]

http://forums.adobe.com/thread/459530