[Hit Counter? Hits Updation]

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]

[MySQL - MD5 vs Password]

as far as MD5 goes

it's much better to reverse your string

MD5 that

then reverse the MD5

and MD5 that

 

makes it impossible to hack

 

In reference to this post

http://www.phpfreaks.com/forums/index.php?...topic=76708&hl=

314034[/snapback]

 

Quick question.

 

If you can unencrypt MD5, why would you bother to reverse, and THEN MD5 that? Isnt that just wasting time?

 

[Dreamweaver .php pages]

How do you create a project in DW? Never heard of or used that feature...