Code to calculate the Virality of Social Networks.

Wizpert6.php

<?php

$social = "TWITTER";
$result1 = mysql_query("SELECT * FROM table3") or die("Cannot get the results!");
$visits = mysql_num_rows($result1);

$result2 = mysql_query("SELECT * FROM table3 WHERE SOCIAL_SITE='".$social."'") or die("Cannot get the results!");
$clicks = mysql_num_rows($result2);
$virality = $clicks / $visits * 100;

echo $social.": Clicks ".$clicks." of visited ".$visits." has the Virality of <b>".$virality."%</b>";