Topic awaiting preservation: php mysql problem (Page 1 of 1)

<?php
header("Content-type: image/png");
$datab=mysql_connect("localhost", "db", "pass");
mysql_select_db("bloodonthecanvas_com_1");
$id=trim($id);
$ip = GetHostByName($REMOTE_ADDR); 
MYSQL_QUERY("INSERT INTO `farrierhits` (`ip`) VALUES ('$ip')");
$vis=mysql_QUERY("SELECT COUNT(DISTINCT(`ip`)) FROM `farrierhits`");
$widthcalc=strlen($vis);
$px    = 7.5 * $widthcalc;
$im    = imagecreatefrompng("images/button1.png");
$orange = imagecolorallocate($im, 255, 0, 0 );
$font = imageloadfont("timesbd.ttf");
imagestring($im, $font+5, 0, 0, $vis, $orange);

imagepng($im);
mysql_close($datab);
imagedestroy($im);

?>

ok this is an image i have which is suposed to be a hit couter but at the moment it is logging each hit twice and i cant figure out why
can anyone help?
p.s. it might be a little messy as i have been messing around with it trying to figure out the problem

2 things.

What do you mean by "loggin each twice"? There's no loop apperent in the code so I'm assuming you don't mean being logged twice in the db.

What is this supposed to be doing

$widthcalc=strlen($vis);

If I'm reading this right $vis is holding a mysql result set so I'm not sure what you're getting by doing strlen on it.

- Butcher -

you're sure the image isn't on teh page twice?



.:[ Never resist a perfect moment ]:.

sorry, i was quite tired when i posted this
im not quite sure about why thats there
and yes it does log each entry in the database twice