Hit counters for all the individual records of one table in the database. PHP

Hi there! Can any one tell me who to do a Hit counter for all the individual records of one table in the database. There is a topic related to that in this site, but it´s in asp, and not in php. ( Where is the link - http://dmxzone.com/ShowDetail.asp?NewsId=836 )

Please help:)

Thanks

Comments

The theory is the same, even the SQL is close

January 15, 2005 by Chris Charlton

Same theory, instead you'd run an UPDATE with PHP/MySQL. When you pull down the record (Recordset), pull down the current hit count and use that value, and add 1 to it, then run your UPDATE SQL. Personally I'd move the hit-count to a seperate table, but that's not always neccessary. If you are handy with hand-coding, then make yourself a function so you only need to make a 1-line call each time to update a record hit count. Hope these tips help. :)

Re Hit Hounter

January 1, 2006 by Malcolm X

Hey, thanks for the tutorial. I have been looking for something like this for a few weeks now. Although I am getting an error everytime I try to search my database now. Something like this.

Microsoft JET Database Engine error '80040e14'
Syntax error (missing operator) in query expression 'TimberSpecies ='.
/html/results.asp, line 68
Line 68: Command1.Execute()

Can anyone help me?

You must me logged in to write a comment.