if (!$id) { error("You didnt specify an id number"); }

// set up the connection
$connection = mysql_connect("localhost", "", "");
if (!$connection) { error("Unable to connect with your login info for MySQL", $connection); }

// connect the database
$db = mysql_select_db("', $connection);
if (!$db) { error("Unable to connect to database", $connection); }

// set up the query
$query = "SELECT * FROM Links_Links WHERE ID = $id";

// now do a while to print out the HTML code to show the categories..
$result = mysql_query($query);
if (!$result) { error("Unable to execute query to mySQL Database.", $connection); }

//start putting into the HTML
while ($cat = mysql_fetch_array($result)) {

$count = $cat[view];

} // end of the while

$count++;

mysql_close($connection);

// set up the connection
$connection = mysql_connect("localhost", "", "");
if (!$connection) { error("Unable to connect with your login info for MySQL", $connection); }
// connect the database
$db = mysql_select_db("", $connection);
if (!$db) { error("Unable to execute command", $connection); }
// now create ther query and use it to update the field number...
$query = "UPDATE Links_Links SET view = $count WHERE ID = $id";
$result = mysql_query($query);
$error = mysql_error();
if (!$result) { error("Unable to execute query to mySQL Database! Reason: $error", $connection); }
mysql_close($connection);


echo "<img src=\"http://www.site.com/pixel.gif\" width=1 height=1>";


// erorr sub incase we get probs!
function error($error, $connection) {

echo $error;
mysql_close($connection);
exit;

}

UPDATE Links_Links SET views = views + 1 WHERE ID = $id

mysql> SELECT COUNT(*) FROM lsql210_Links WHERE ID = 123456;
+----------+
| COUNT(*) |
+----------+
| 1 |
+----------+
1 row in set (0.04 sec)

'link_views' => 'sub {
my $vars = shift;
$DB->table("Links")->update({ views => \"views + 1" }, { ID => $vars->{ID} });
return;
}'