Php counter

im trying to add a visitor counter to my homepage i downloaded the script but not sure what to do and where to put things to get it running this is the counter script...
// Connect to server and select database.
mysql_connect(''$host'', ''$username'', ''$password'')or die(''cannot connect to server '');
mysql_select_db(''$db_name'')or die(''cannot select DB'')
$tbl_name=''counter''; // Table name
$sql=''SELECT * FROM $tbl_name'';
$result=mysql_query($sql);
$rows=mysql_fetch_array($result);
$counter=$rows['counter'];
// if have no counter value set counter = 1
if(empty($counter)){
$counter=1;
$sql1=''INSERT INTO $tbl_name(counter) VALUES('$counter')'';
$result1=mysql_query($sql1);
}
echo ''You 're visitors No.''
echo $counter;
// count more value
$addcounter=$counter+1;
$sql2=''update $tbl_name set counter='$addcounter''';
$result2=mysql_query($sql2);
mysql_close();
?>

and this is mode homepage code..
<table id=''tablelayout''>
<tr>
<td><table id=''tableNav'' >
<tr>
<td><img src=''images/logo.gif'' width=''350'' height=''117'' /></td>
<td valign=''bottom''><a href=''index.php''><img src=''images/smallbutton1.gif'' width=''92'' height=''30'' border=''0'' /></a></td>
<td valign=''bottom''><a href=''phpdenora/index.php''><img src=''images/smallbutton2.gif'' width=''92'' height=''30'' border=''0'' /></a></td>
<td valign=''bottom''><a href=''irpg/index.php''><img src=''images/smallbutton3.gif'' width=''92'' height=''30'' border=''0'' /></a></td>
<td valign=''bottom''><a href=''forum_system/main_forum.php''><img src=''images/smallbutton4.gif'' width=''92'' height=''30'' border=''0'' /></a></td>
</tr>
</table>
<table width=''95%'' align=''center'' cellspacing=''3'' id=''loginbar''>
<tr>
<td align=''right''><a href=''login_system/main_login.php''>LOGIN</a></td>
</tr>
</table></td>
</tr>
<tr>
<td id=''tdTableCenter''><table id=''mainButtons'' >
<tr>
<td id=''tdtopButton''><a href=''phpdenora/index.php''><img src=''images/bigbutton1.gif'' width=''167'' height=''36'' border=''0'' /></a></td>
<td id=''topButtonRight''><p>Wanna find out all the latest upto date infomation<br />
on the AbZoRbeD network, Then check this out.</p>
</td>
</tr>
<tr>
<td id=''tdbottomButton''><a href=''irpg/index.php''><img src=''images/bigbutton2.gif'' width=''167'' height=''36'' border=''0'' /></a></td>
<td id=''topButtonBottom''><p>Dont idle for no reason join in the game and have<br />
a little fun battling against the other players.</p>
</td>
</tr>
<tr>
<td id=''tdbottomButton''><a href=''forum_system/main_forum.php''><img src=''images/bigbutton3.gif'' width=''167'' height=''36'' border=''0'' /></a></td>
<td id=''topButtonBottom''><p>Use this forum for discussing all kinds of <br />
topics you must be registered and logged<br />
in to access this area if you would like<br />
to register <a href=''login_system/insert.php''>Click Here</a> </p></td>
</tr>
</table></td>
</tr>
<tr>
<td><table id=''tableFooter'' >
<tr>
<td id=''tdFooterLeft''>&nbsp;</td>
<td id=''tdFooterCenter''><p class=''style1''><a href=''contactus/contactus.htm''>Contact Us</a><br />
&copy; AbZoRbeD.net 2007-2009</p>
</td>
<td id=''tdFooterRight''></td>
</tr>
</table></td>
</tr>
</table>
any help would be grate :)