link's click count in database

See more:

SQL

PHP

sir, there is advt_hit column in database,
my query is below, I display in short:

if($num<>0) 
		{
		while($services = mysql_fetch_array($services_result)){?>				   

<a target="_blank" id="<?php echo $services[" class="content_blue1" href="http://`<?`php echo $services['advt_link'];?>"><font size="1"><b>    

<?php <br mode="hold" /?>
if($advt_link==$fixtext)    
		{    
////				echo 'nolink';    
		}    

else if($advt_link==null)     
	{     
//		 echo 'empty';     
	   }    
else      
	{     
	echo '&lt;img src="more_infoimage.gif" alt="More Info." /&gt;';     
	}    
     
/*  origional and working below     
if($advt_link!=null)    
		{     
		echo "More Info.";    
		}      
else    
	{    
		 //	echo 'jagdish';      
	} 
?&gt;     
</b></font></a>   

Note:
A) u can see that my query **is fetch with while loop...**
B) i want to count ***hit for specific link on clicked ..***
C) and also i want to add perpage 10 result

plz help... i try to search solution for this query on internet by different-different website but i cant find answer as my requirement..
plz help..help..........
thanks