Hello again!
I\'ve got a total hits script that I kinda got from an old nuke site. The script does incriment the database just fine. But when I call the result, I get \"Resource id #4\"
What the heck am I doing wrong?
Database:
# Table structure for table `hits`
#
CREATE TABLE hits (
type varchar(80) NOT NULL default \'\',
var varchar(80) NOT NULL default \'\',
count int(10) unsigned NOT NULL default \'0\'
) TYPE=MyISAM;
#
# Dumping data for table `hits`
#
INSERT INTO hits VALUES (\'total\', \'hits\', 45612);
Here is the header script: (this works fine. stolen from nuke)
include_once \'db.php\';
mysql_query("UPDATE hits SET count=count+1 WHERE (type=\'total\' AND var=\'hits\')");
Here is the footer scriipt:
$total_hits = mysql_query("SELECT count FROM hits WHERE type=\'total\' AND var=\'hits\'");
echo "$total_hits";
Thanks in advance!