Welcome to the P2L Network Forums!
Main Forum Options
Advanced MySQL Hit Counter Tutorial., Take a look :) |
Rating
|
  Sep 9 2006, 10:55 AM
Post
#1
|
|
|
P2L Staff  Group: Admin
Posts: 2,193
Joined: 27-July 06
From: UK
Member No.: 20,698
Publishing: My Tutorials
 |
This tutorial has been moved to publishing...
http://www.pixel2life.com/publish/tutorial...utorial_on_p2l/ Thanks. This post has been edited by . Adam .: Dec 19 2007, 04:16 PM |
 |
 
|
|
Sep 9 2006, 04:46 PM
Post
#2
|
|
|
P2L Staff Group: Admin
Posts: 2,193
Joined: 27-July 06
From: UK
Member No.: 20,698
Publishing: My Tutorials
|
 Comments Welcome- Adam 
|
|
|
|
|
Sep 9 2006, 08:29 PM
Post
#3
|
|
|
Jedi In Training  Group: Members
Posts: 352
Joined: 16-July 06
From: Hastings, Hawkes bay, New Zealand
Member No.: 20,433
Publishing: My Tutorials
|
Very Very nice tutorial. Basic yet very effective and easy to implement. Great work adam thats a really nice hit counter!
|
|
|
|
|
Sep 10 2006, 05:03 AM
Post
#4
|
|
|
P2L Staff Group: Admin
Posts: 2,193
Joined: 27-July 06
From: UK
Member No.: 20,698
Publishing: My Tutorials
|
Thanks
 I hope to write some more tutorials just as good, maybe even better  - Adam
|
|
|
|
|
Sep 17 2006, 02:37 PM
Post
#5
|
|
|
Young Padawan Group: Members
Posts: 189
Joined: 16-May 06
From: United Kingdom
Member No.: 18,739
Publishing: My Tutorials
|
Tutorials posted on these forums are meant to be exclusive to P2L, especially if you have gotten a custom member title for writing it, yet you have posted it on this website.
http://www.techtuts.com/?view=tutorials&am...rial&id=962 |
|
|
|
|
Sep 17 2006, 02:48 PM
Post
#6
|
|
|
P2L Staff Group: Admin
Posts: 2,193
Joined: 27-July 06
From: UK
Member No.: 20,698
Publishing: My Tutorials
|
Hang on....
I asked Donna Shall I post this? reply: yes Point Made  - Adam
|
|
|
|
|
Sep 17 2006, 02:49 PM
Post
#7
|
|
|
Young Padawan Group: Members
Posts: 189
Joined: 16-May 06
From: United Kingdom
Member No.: 18,739
Publishing: My Tutorials
|
Ah ok
Didn't know.
|
|
|
|
 Sep 17 2006, 03:22 PM
Post
#8
|
|
|
P2L Staff Group: Admin
Posts: 2,193
Joined: 27-July 06
From: UK
Member No.: 20,698
Publishing: My Tutorials
|
QUOTE(Adam C @ Sep 17 2006, 08:49 PM)  Ah ok Didn't know.Ok lol - Adam
|
|
|
|
|
Sep 17 2006, 10:28 PM
Post
#9
|
|
|
Young Padawan Group: Members
Posts: 292
Joined: 5-August 06
From: NSW Australia
Member No.: 21,333
Publishing: My Tutorials
|
Nice post Adam. This will come in handy somewhere shortly. I might even modify it slightly.
Thanks again champ!
|
|
|
|
|
Sep 19 2006, 02:59 PM
Post
#10
|
|
|
Lead Forum Admin Group: Admin
Posts: 11,945
Joined: 29-September 04
From: Canada
Member No.: 111
Publishing: My Tutorials
|
QUOTE(Adam C @ Sep 18 2006, 08:49 AM) Ah ok Didn't know. unsure why you have reported this he asked if he could post it, it maybe pointless to you but many new members will think otherwise.Please don't use the report post when there is nothing to report thanks |
|
|
|
|
Sep 23 2006, 10:14 AM
Post
#11
|
|
|
Young Padawan Group: Members
Posts: 56
Joined: 23-July 06
Member No.: 20,596
Publishing: My Tutorials
|
QUOTE Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home2/ali/public_html/hit.php on line 14 :s
This post has been edited by emcfc: Sep 23 2006, 10:27 AM |
|
|
|
|
Sep 26 2006, 04:14 PM
Post
#12
|
|
|
P2L Staff Group: Admin
Posts: 2,193
Joined: 27-July 06
From: UK
Member No.: 20,698
Publishing: My Tutorials
|
QUOTE(emcfc @ Sep 23 2006, 04:14 PM) QUOTE Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /home2/ali/public_html/hit.php on line 14 You have done the SQL and your config file is correct? - Adam
|
|
|
|
|
Sep 27 2006, 09:58 AM
Post
#13
|
|
|
Young Padawan Group: Members
Posts: 2
Joined: 13-August 06
Member No.: 21,865
Publishing: My Tutorials
|
Hi there, just tested this out and found that the SQL does not run properly..
Error SQL query: CREATE TABLE `stats` ( `ip` varchar( 20 ) NOT NULL default '', `date` varchar( 10 ) NOT NULL default '00-00-0000', `hits` int( 10 ) NOT NULL default '1' ) ENGINE = MYISAM DEFAULT CHARSET = latin1; MySQL said: Documentation #1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1' at line 5 |
|
|
|
|
Sep 27 2006, 10:05 AM
Post
#14
|
|
|
P2L Staff Group: Admin
Posts: 2,193
Joined: 27-July 06
From: UK
Member No.: 20,698
Publishing: My Tutorials
|
QUOTE(Markster @ Sep 27 2006, 03:58 PM) Hi there, just tested this out and found that the SQL does not run properly.. Error SQL query: CREATE TABLE `stats` ( `ip` varchar( 20 ) NOT NULL default '', `date` varchar( 10 ) NOT NULL default '00-00-0000', `hits` int( 10 ) NOT NULL default '1' ) ENGINE = MYISAM DEFAULT CHARSET = latin1; MySQL said: Documentation #1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1' at line 5 CODE CREATE TABLE `stats` ( `ip` varchar(20) NOT NULL default '', `date` varchar(10) NOT NULL default '00-00-0000', `hits` int(10) NOT NULL default '1' ) ENGINE=MyISAM; Try that - Adam
|
|
|
|