help needed

[MattWeet]

i want to code a basic link tracker that counts how many times some links have been clicked and displays the amount on the page. I want all the link tracks to be added together, eg:

Link one: 2 clicks
Link three: 7 clicks

Total Clicks: 9

any way i can do this (with simplicity...i am a very very new php coder)?

[planetsim]

The basics the way i see link trackers are

One section - Link gets added to database
Another section - Shows a list of all the links
Finally - Goes to site with a query string - Updates Hits + 1

Im assuming you have some sort of Form to add the Links or your doing it manually.

Now i hope you have MySQL access or access to some database, it wont differ much from other dbs

Firstly
the Links Tbl

TBL Name: links
id|title|linkaddress|hits

Showing all Links

//Connect and select database

$linkid = mysql_connect("","",""); //your inform host,user,pass
mysql_select_db("",$linkd); //add your dbname

$query = mysql_query("SELECT * FROM links ORDER BY hits DESC"); //gets all links and descends in most hits to lowest hits
$totalhits = 0; //this is your total counter
while($r = mysql_fetch_array($query)){
//display the links the way you want here
$totalhits = $totalhits + $r['hits'];  //this gets the totalhits so if 10 then its $totalhits = 10 + the hits for that link
}

echo "Total Clicks".$totalhits;

Its not tested but it should sorta work, if you put the correct information in.
Hope this sorta helps a little

[drag0n]

This is the section where u display all the links in the database

<?php
//Connect and select database 

   $linkid = mysql_connect("","",""); //your inform host,user,pass 
             mysql_select_db("",$linkd); //add your dbname
   $sql_links ="SELECT *FROM links ORDER BY hits DESC";
   $result_links = mysql_query( $sql_links ) or die( mysql_error() );
//Print out all the links in the database
while( $links = mysql_fetch_array( $result_links ) )
{
echo "<a href=\"http://www.domainName.com/links.php?id=" . $links[id] . "\">" . $links[name] . " - " . $links[hits] . "</a>";
}
?>

This is links.php which will track the links and send them to their link

<?php
//Connect and select database 

   $linkid = mysql_connect("","",""); //your inform host,user,pass 
             mysql_select_db("",$linkd); //add your dbname
   $result_links = mysql_query( $linkid ) or die( mysql_error() );
   $sql_update = "UPDATE links SET hits = hits + 1 WHERE id = '" . $_GET[ 'id' ] . "'";
   $result_approve = mysql_query( $sql_update ) or die( mysql_error() );
   $links = mysql_fetch_array( $result_links ) 
   		header( "Location: " . $links[ "url" ] . "");
		exit;
?>

I am very rusty with php, I havent touched it in at least 5 month so please dont laugh at my scripts instead tell me my mistakes... I really needed the practice, so please tell me my mistakes. Thanks in advanced.

[MattWeet]

hrrm ok thanks

[planetsim]

$result_links = mysql_query( $linkid ) or die( mysql_error() );
$sql_update = "UPDATE links SET hits = hits + 1 WHERE id = '" . $_GET[ 'id' ] . "'";

Firstly $result_links query its not needed as it doesnt do anything from what i can see

Secondly $result_approve this variable isnt needed on the query.

[MattWeet]

can i do this without mysql?