mysql count an acctual value:

PoorDoggie · 08-27-2006, 08:09 AM

I have this code at the moment:

PHP Code:

  $sql = "SELECT user_id, count(points) AS count_points FROM trans WHERE type_id!='30' AND type_id!='40' GROUP BY user_id ORDER BY count_points DESC LIMIT 100"; 

????: NamePros.com http://www.namepros.com/programming/231966-mysql-count-an-acctual-value.html

but it isn't acctually counting the points. count_points to acctually be a tally of the amount of points each unique user_id has. Everytime a user earns points it is stored into the database, so it needs to add the value of every "point" field for that specific user!

Any help would be most appreciated.

Thanks
Tom

sdsinc · 08-27-2006, 08:29 AM

It looks OK at first glance.
Did you try without the WHERE clause ?

Scott · 08-27-2006, 08:43 AM

use sum(points) instead of count(points)

PoorDoggie · 08-27-2006, 10:19 AM

thanks scott

sdsinc thanks for your help - but the where clause is pretty important, and if I took it out... well

but thanks

08-27-2006, 08:09 AM	THREAD STARTER #1 (permalink)
PoorDoggie Soon to be RICHdoggie! Join Date: Jan 2005 Location: UK Posts: 2,408	mysql count an acctual value: I have this code at the moment: PHP Code: `$sql = "SELECT user_id, count(points) AS count_points FROM trans WHERE type_id!='30' AND type_id!='40' GROUP BY user_id ORDER BY count_points DESC LIMIT 100"; ????: NamePros.com http://www.namepros.com/programming/231966-mysql-count-an-acctual-value.html` but it isn't acctually counting the points. count_points to acctually be a tally of the amount of points each unique user_id has. Everytime a user earns points it is stored into the database, so it needs to add the value of every "point" field for that specific user! Any help would be most appreciated. Thanks Tom

08-27-2006, 08:29 AM	#2 (permalink)
sdsinc Domains my Dominion Join Date: Aug 2005 Location: Web 1.0 Posts: 9,552	It looks OK at first glance. Did you try without the WHERE clause ? __________________ NameNewsletter.com - free lists of available domain names ZoneFiles.net (beta) - ccTLD and gTLD droplists

08-27-2006, 08:43 AM	#3 (permalink)
Scott Senior Member Join Date: Jun 2003 Location: UK Posts: 3,547	use sum(points) instead of count(points)

08-27-2006, 10:19 AM	THREAD STARTER #4 (permalink)
PoorDoggie Soon to be RICHdoggie! Join Date: Jan 2005 Location: UK Posts: 2,408	thanks scott sdsinc thanks for your help - but the where clause is pretty important, and if I took it out... well but thanks

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)