<?php
$con = mysql_connect("localhost","DFdsfdsaf","sadfsdafdsafdsa");
mysql_select_db("url", $con);
$i=$_GET['id'];
$idx = "http://lyno.in/";
$ids = "$idx$i";
$result = mysql_query("SELECT COUNT(short) FROM traffic where short= '$ids'");
$resul = mysql_query("SELECT distinct ref FROM traffic where short = '$ids'");
$resu = mysql_query("SELECT distinct country FROM traffic where short = '$ids'");
echo "Link: ". $ids ."";
echo "</br>";
while($row = mysql_fetch_array($result)){
    echo "Clicks: ". $row['COUNT(short)'] . "";
    echo "<br />";
}
echo "</br>";
echo "Referer Websites:","</br>";

while($ro = mysql_fetch_array($resul)){
    $r = $ro['ref'];
    $results = mysql_query("SELECT COUNT(short) FROM traffic where ref= '$r' and short = '$ids'");
    while($rows = mysql_fetch_array($results)){
        echo $ro['ref'];
        echo ": ";
        echo $rows['COUNT(short)'];
        echo "<br />";
    }
}
echo "<br />";
echo "Country:","</br>";
while($rowsq = mysql_fetch_array($resu)){
    $rs = $rowsq['country'];
    $results = mysql_query("SELECT COUNT(country) FROM traffic where country= '$rs' and short = '$ids'");
    while($rowss = mysql_fetch_array($results)){
        echo $rowsq['country'];
        echo ": ";
        echo $rowss['COUNT(country)'];
        echo "<br />"
    }
}
?>