Advance MySQL command how can i doe it ?
Posted: Tue Mar 28, 2006 4:00 am
I whot to make a statestik system bot now i run to the troppel.
i hav relly manny insert in my MySQL database when i get the time and ip from on user fx. here
time: 1143533045
ip: 194.19.xxx.xxx
soe now im whot to get all unikke hist every day if you under stand. every day ist one ip adress only can be count whit bot next day the same ip adesse can be count one time more....
soe i need SQL Command if i can doe it whit SQL and not in my PHP code.
i hobe all understand og i hob i can be help here
i hav relly manny insert in my MySQL database when i get the time and ip from on user fx. here
time: 1143533045
ip: 194.19.xxx.xxx
soe now im whot to get all unikke hist every day if you under stand. every day ist one ip adress only can be count whit bot next day the same ip adesse can be count one time more....
soe i need SQL Command if i can doe it whit SQL and not in my PHP code.
i hobe all understand og i hob i can be help here