dolcevita - 4:12 pm on Mar 11, 2013 (gmt 0)
Knowledge of MySql and what to do is very limited by my side. Actually i chose always to do everything without MySql if it is possible.
I can post here table structure:
Column Type Null Default Comments
id int(11) No
page varchar(50) Yes NULL
flag char(2) Yes NULL
country varchar(50) Yes NULL
abrev char(3) Yes NULL
region varchar(50) Yes NULL
city varchar(50) Yes NULL
latitude double Yes NULL
longitude double Yes NULL
time varchar(20) Yes NULL
ip varchar(100) Yes NULL
counter int(11) Yes NULL
url varchar(100) Yes NULL
Inside MySql are inserted information about IP from visitor along with another information's (country, flag letters, latitude, langitude, region etc...).
Counter count how many time visitors have visited website.
Query from my examples above call only field ip in combination with counter (1 means to look only for visitors who have visited website one time).
Hope that you have something from this informations