SELECT Count IP as totalhits from yourtable
Total Sessions = <%= totalhits %>
SELECT COUNT DISTINCT IP as totaluniquehits from your table.
I don't know it the Distinct on Count will work or not but generally this is
what you want to accomplish. count will get you the total number of rows or
entries. Distinct will get you the total number of rows with a unique IP.
StoreFront E-Commerce for Dreamweaver and UltraDev
Total Unique Visitors = <%= totaluniquehits %>
> I made a page hitcounter, and when i want to show the result on my
> i get a result like this.
> Date and time, IP number.
> What i would like to get is:
> Date total hits
> Date and time, IP number
> How can i make a SQL query to get this answer?