July 27th, 2002, 03:35 PM
|
|
|
|
Join Date: Apr 2007
Location: Perth, Australia
Posts: 221
Time spent in forums: < 1 sec
Reputation Power: 3
|
|
|
mixing groups
okay, im not that great with SQL, just know the basics, but what i been trying to do, is something similar to matts poll that he has at the moment.
php Code:
 Original
- php Code |
|
|
|
SELECT *, ((num_votes/SUM(num_votes))*100) AS num_votes FROM poll_options WHERE poll = $poll
that is my SQL statement which i wanted to find the percent which each poll result has, although i get this error
php Code:
| Original
- php Code |
|
|
|
Mixing of GROUP columns (MIN(), MAX(), COUNT()... ) with no GROUP columns is illegal if there is no GROUP BY clause
any help is much appreciated
|
Codewalkers Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
