Creating a simple hit counter?

[Simon Lloyd]

Hi all i have created a new database called mycounter and then created a plugin like this
Product : VBulletin
Hook Location :Global_Start
Title: Hit Counter
Execution Order : 5
Plugin PHP Code :

PHP Code:

<if condition="$show['member']">
$result = mysql_query("SELECT count FROM mycounter"); 
$mycounter = mysql_result($result, 0) + 1; 
$result = mysql_query("UPDATE mycounter SET count = count + 1");
</if> 


i then added this to my desired page:

PHP Code:

<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="10%" align="center">
<td class="tcat"><center>Hit Counter</td>
<tr align="center"><td font size="+2" color="blue">$mycounter 
</td></tr>
</table> 


My problem is that it won't show the count unless i remove the if condition, i'm no coder, but what i am trying to do is just count the number of members who visit the page not guests, can anyone help?