Topic awaiting preservation: cont different (Page 1 of 1)

oh what i have is a list of ip adresses and pages that they viseted in my a table but each page they visited is a seperate row so how can i count all the different ip adressess to determine unique visitors

MySQL: SELECT COUNT(DISTINCT(`user_ip`)) FROM `my_table`

If you're going to count like that, you should probably assign the result to something so it can be called up later on, so 'SELECT COUNT(DISTINCT('user_ip')) AS unique_ip FROM my_table' would be more appropriate I think


Justice 4 Pat Richard

What is the advantage to doing it that way skaarjj?

It just names the result. I think if you don't do it that way you end up with something like mysql_result_array['count'] or something like that.



.:[ Never resist a perfect moment ]:.

Right.

now whenever I call anything out of the DB, I assign it to a variable name in PHP - in this case something like $unique_ip.

is there any actual advantage to adding the "as" part in a case like this?

So far I've only used such things when I am combining or calculating values.

My reason (in context) for not using 'AS':

// MySQL connection open and database selected...
$query = "SELECT COUNT(DISTINCT(`user_ip`)) FROM `my_table`";
$result = mysql_result($query);
$ip_count = mysql_result($result,0);
// Whatever else here...

Which is perfectly valid. I usually, when i'm counting fields, always apply them to names with AS since when I'm doing it I end up doing multiple counts of interrelated fields (now we get into complex, multi-pathed SQL statements) so assigning them ot names helps to keep things clear. In a single count situation as this it's not necessary, it's just habit.


Justice 4 Pat Richard

Thanks for clarification =)

Another way to do this is to take each ip returned from " SELECT ip FROM site_info " and assign each item returned to an assosiative array with the name of the value returned.

while ($row=mysql_fetch_array($result)){
		
             foreach ($row as $key => $value){
			
			$ip[$value]=$value;
			
			
		}
		
		
}

You are then left with an array of unique values only.

/* Sure, go ahead and code in your fancy IDE. Just remember: it's all fun and games until someone puts an $i out */

True, but whyp ut your server through the extra processing load when you can just get the SQL to count it all up for you?


Justice 4 Pat Richard

You wouldn't, if you were just counting. But you would if you wanted to list the unique IP's instea of just counting them.

quote:

---

But you would if you wanted to list the unique IP's instea of just counting them.

---

in that case why not simply doing :

MySQL: SELECT DISTINCT(`user_ip`) FROM `my_table`

quote:

---

True, but whyp ut your server through the extra processing load when you can just get the SQL to count it all up for you?

---

Most of the time we are hitting a MySQL database (localhost)on the same box as the webserver so the same server handles the load either way. I'm not dead sure about this, but I'm willing to bet that the database is more efficient at this than php though...

I just wanted to provide an another way of doing this sort of thing. this way will work with data from xml, csv, and any other data source.

/* Sure, go ahead and code in your fancy IDE. Just remember: it's all fun and games until someone puts an $i out */

quote:

---

poi said:

in that case why not simply doing :
code:

MySQL: SELECT DISTINCT(`user_ip`) FROM `my_table`

---

Mainly because I simply wasn't thinking when I posted =)