Click tracking

[rIkLuNd]

I'm making a little download system for my site, but there is just one thing left; the counter. I don't know how to increase the 'clicks' value in my MySQL table...

The structure:

index.php:
This is where you click the link, and then you come for example to the page 'download.php?file=1'. How should I do to increase the value of the 'clicks' value?!

download.php:

Please help me with the content of this file! I know how to make it downloable (meta), and I know how to get the values of the table fields ([man]mysql_fetch_assoc[/man]).

[aSa]

Ex:

<?php
//i suppose you successfully connected to your db
//First get the old download_count:

$q = mysql_query("Select download_count, file_path from your_table where id=$_GET['file_id']");

$row =mysql_fetch_array($q);
//now add 1
$row['download_count']++;
//update your record

mysql_query("UPDATE your_table SET download_count = $row[download_count] WHERE id=$_GET[file_id]");

//now send your file:

header("Location: $row[file_path]");

?>

i hope it works.

😉

[Weedpacket]

You know it might be easier to just go

UPDATE your_table SET download_count = download_count + 1 WHERE id=$_GET[file_i]

And then you don't need the SELECT and ancillary PHP.

[rIkLuNd]

Yes, it worked! Wohoo!