Thread: Profile hit counter ?

ok update you can insert this into your database chage the values to fit your needs

PHP Code:

CREATE TABLE `TrackAll` (
  `ProfileID` mediumint(9) NOT NULL default '0',
  KEY `ProfileID` (`ProfileID`)
) TYPE=MyISAM; 


then in profile.php insert this

PHP Code:

db_res ("INSERT INTO `TrackAll` ( `ProfileID`) VALUES ('$ID')"); 


and then i member.php insert

PHP Code:

$counter = db_arr("SELECT COUNT(*) FROM `TrackAll` WHERE `ProfileID` = {$profileID}"); 


AND REPEAT THE STEPS I DID FOR THE OTHER COUNTER

what this does is everytime the profile is viewed it automatically inserts the profile id into the database no matter who views it .

I followed that exactly, and I got "database access error". I give up haha

what does the error say ? when it sends the email report?

Error in /member.php: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Query: 'SELECT COUNT(*) FROM `TrackAll` WHERE `ProfileID` = '

What lines do I need to insert your code? And the MySQL query was perfect, so its not that.

what that mean is its not finding the number you inputed your syntax is probaly wrong in the select statement make sure in the where clause it says WHERE `ProfileID` = {member['ID']}

I put exactly what you instructed. Im confused.

post your script of exactly how it looks in your php files