Track downloads with PHP?

$result = mysql_query("SELECT * FROM product_downloads WHERE name = '$product'");
$row = mysql_fetch_array($result);
if (strlen($row) != 0)
{
	$total = ++$row["downloads"];
	$result = mysql_query("UPDATE product_downloads SET downloads='$total' WHERE name = '$product'");
}

What a mess! Replace the whole lot with :

$result = mysql_query("UPDATE product_downloads SET downloads=(downloads+1) WHERE name = '$product'  LIMIT 1");

Now that's better.