Ok i am making a tracking script to track my users go here
http://www.bishopbeater.com/trackingclicks.php it says
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /mnt2/users/jonhill/jonhill/bishopbeater.com/html/trackingclicks.php on line 5
heres my code for trackingclicks.php
<?
mysql_pconnect("mysql.4ph.com","jonhill","changeme");
mysql_select_db("counter");
$result = mysql_query("select * from counter WHERE url=\'$url\'");
while($r=mysql_fetch_array($result))
{
$id=$r["id"];
$count=$r["count"];
$url=$r["url"];
$count++;
$update = "UPDATE counter SET count=\'$count\' WHERE id=$id";
$updatesql = mysql_query($update);
?>
<script language="JavaScript">
document.location.href="<?php echo $url;?>"
</script>
<? } ?>
if anyone can help me id appreciate it thanks.