mysql count an acctual value:

PoorDoggie · 08-27-2006, 07: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";

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, 07:29 AM

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

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

use sum(points) instead of count(points)

PoorDoggie · 08-27-2006, 09: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, 07:09 AM	#1 (permalink)
PoorDoggie Soon to be RICHdoggie! Join Date: Jan 2005 Location: UK Posts: 2,390 316.50 NP$ (Donate)	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";` 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 __________________ █ Exchange your long URL for a much smaller one! █ Free Anonymizer/Proxy █ Taz Martin's blog - Learn all about internet marketing, promoting your website and much more!

08-27-2006, 07:29 AM	#2 (permalink)
sdsinc Domains my Dominion Join Date: Aug 2005 Location: Web 1.0 Posts: 6,284 1,095.94 NP$ (Donate)	It looks OK at first glance. Did you try without the WHERE clause ? __________________ Buy now - MassDeveloper.com $500

08-27-2006, 09:19 AM	#4 (permalink)
PoorDoggie Soon to be RICHdoggie! Join Date: Jan 2005 Location: UK Posts: 2,390 316.50 NP$ (Donate)	thanks scott sdsinc thanks for your help - but the where clause is pretty important, and if I took it out... well but thanks __________________ █ Exchange your long URL for a much smaller one! █ Free Anonymizer/Proxy █ Taz Martin's blog - Learn all about internet marketing, promoting your website and much more!

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

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