hits

[brown2005]

hits_user              

hits_user_type              

hits_date            

hits_count        

 

I have that table and

 

$sql = "SELECT year(hits_date) AS hits_year, COUNT(*) AS hits_unique, SUM(hits_count) AS hits_count

         FROM z_hits

       GROUP BY year(hits_date)

ORDER BY year(hits_date) DESC;";

 

which works fine and lists the years with the hits and unique hits, but obviously its not the fully unique hits because it is just counting the rows, so you could have two of the same user in the table, so how would i get around this?

 

thanks in advance

[marcus]

Before updating the row check if the row already exists.

 

$sql = "SELECT * FROM `yourtable` WHERE `hits_users` ='whatever'";
$res = mysql_query($sql) or die(mysql_error());

if(mysql_num_rows($res) == 0){
//insert new row
}else {
//update existing row
}

[brown2005]

im not updating a row, i am showing hits to my website

[pocobueno1388]

If you want to show the hits by a specific user, just add to your query:

 

<?php

$sql = "SELECT year(hits_date) AS hits_year, COUNT(*) AS hits_unique, SUM(hits_count) AS hits_count
FROM z_hits
WHERE hits_user = 'username'
GROUP BY year(hits_date)
ORDER BY year(hits_date) DESC;";

?>

 

If that is not what you are looking for, I don't understand your question.

[brown2005]

sorry let me explain a bit more,

 

i want to show

 

year

hits

unique

 

 

i use

 

year - year(hits_date) AS hits_year

hits - SUM(hits_count) AS hits_count

unique - COUNT(*) AS hits_unique

 

but obviously the COUNT(*) is countin all the rows, and giving 88 unique users when there is less because some people have visited the site, more than once on different days...

 

 

 

[brown2005]

ne1?