Is there such a script??

[Nalco]

I am looking for a script that can record how many times a link has been clicked. The catch is, that I would like to output the the data to a public page that would disply the usernames, how many times they clicked the link total, and maybe the time and date of their last click.

Is this possible??

The other problem that I have, is that I have no existing user database, so I would need to have people be able to register for this script. I actually only need to track 2-3 links. My site runs a Mysql DB.

I have looked high and low, and the most I can come up with, is just the counter.

I cant seem to find anything that will record and display the user name and how many times each user clicked the link.

Thanks!

[Mordecai]

It would be easy to alter the link-click counter scripts you've found. If you know how to use MySQL, you should be able to construct a table that will be able to record this information for all users.

Here's an example of a query that would make a good table:
CREATE TABLE linkclicks (ammount INT, user TEXT, time TEXT)

"time" would only be TEXT if you were using date(). If you plan on using a UNIX timestamp, it'd be INT.

Now, everytime the link is counted, have it update the ammount:
$result = mysql_query("SELECT * FROM linkclicks") or die("Error querying database.");
while ($line = mysql_fetch_array($result, MYSQL_NUM)) {
$ammount = $line[0];
}
$ammount += 1;

Then run this query to update it:
UPDATE linkclicks SET ammount=$ammount WHERE user="$username"

[er0k]

that wouldnt work unless you were looking to count links with info in the db...

[JakesSA]

you would have to write to the db then redirect it to a new page
eg

$x= "INSERT INTO clicked SET id = .....";

$result = mysql_query($x, $dbConn)

if($result == true) {
header("location: ...hmmmmm");
    }
   else
    {
  echo "sorry";
  }