God, it's been forever since I posted last! And of course, I'm still asking for help. Sigh.. :) [code] include("bWd/includes/db.php"); $ref = $_GET['ref']; $sql = "SELECT * FROM misc WHERE ref = '$ref'"; db_connect(); $result = mysql_query($sql) or die('Query failed. ' . mysql_error()); if (mysql_num_rows($result) == 1) { while ($row = mysql_fetch_array($result)) { $insert = "UPDATE misc SET hits = ".$row['2']++."WHERE ref = '$ref'"; mysql_query($insert) or mail('roughnroudy@gmail.com', 'Minvera Index DB Error', (mysql_error())); } } [/code] Anyway, heres the error: Parse error: parse error, unexpected '\"' in /hsphere/local/home/minvera/minvera-fx.com/index.php on line 19 Im not missing any basic things like semi colons etc, at least as far as I can tell. This is my first attempt at a hit counter, so I thought I would come and ask the pro's when I got stuck. So here I am! :) Basically, when I get a hit from a website that I have done (from the template desigh by link at the bottom of pages) I want to be able to tell who from and how many. [code] CREATE TABLE `misc` ( `id` int(255) NOT NULL auto_increment, `ref` varchar(255) NOT NULL default '', `hits` varchar(255) NOT NULL default '', `info` varchar(255) NOT NULL default '', PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=2; [/code]
