0) { $query = "SELECT * FROM $userstable WHERE ID = '$linkNum'"; $result = MYSQL_QUERY($query); if ($result>0) { $number = MYSQL_NUMROWS($result); //print "number=$number
"; if ($number>0) { $theURL = mysql_result($result,0,"URL"); // print "URL = $theURL
"; // $s=sprintf("",34,34,34,34); $s=sprintf("",34,34,34,34); // print $s; print "\n"; print "\n"; //print "\n"; print "\n"; print "\n"; print "\n"; print "\n"; print"\n"; // now update hit counter $hits = mysql_result($result,0,"hits"); $hits=$hits+1; $query = "UPDATE $userstable SET hits = '$hits' WHERE ID = '$linkNum'"; $result = MYSQL_QUERY($query); // now update linkclicks $ID=0; $user=0; // not defined yet $clicktable="linkclicks"; $timestamp=NULL; $query = "INSERT INTO $clicktable (ID,link,user) VALUES('$ID', '$linkNum', '$user')"; $result = MYSQL_QUERY($query); } } } print ""; /* Close the database connection */ MYSQL_CLOSE(); /* CREATE TABLE linkclicks ( ID int(10) unsigned DEFAULT '0' NOT NULL auto_increment, timestamp timestamp(14), link int(11) DEFAULT '0' NOT NULL, user int(11) DEFAULT '0' NOT NULL, PRIMARY KEY (ID) ); */ ?>