This is my table which I used to get access time of users at every single minute.
-- -- Table structure for table `members_log` -- CREATE TABLE IF NOT EXISTS `members_log` ( `SrNo` int(11) NOT NULL AUTO_INCREMENT, `UserName` varchar(25) NOT NULL, `access_time` datetime NOT NULL, PRIMARY KEY (`SrNo`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;
I used this query in my connection file.
mysql_query("INSERT INTO members_log (UserName,access_time) VALUES ('$_SESSION[myusername]',NOW())");
Now I want to add more functionality in it.
I want to know user click which page of DB when time inserted.