|
|
|
|
|
|
![]() |
#1 |
They have the Internet on computers, now?
Join Date: Sep 2003
Posts: 142
|
Problem In PHP..
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. |
![]() |
![]() |
|
|