query, count, group

[bimmer528]

Hi all, I am having a problem and hoping someone can give me a hand.

mysql_select_db($database_connectionname $connectionname);
$query_simplequeryname = "SELECT COUNT(*) field1, field2 FROM table GROUP BY field2 ORDER BY field1 ASC";
$simplequeryname = mysql_query($query_simplequeryname, $connectionname) or die(mysql_error());
$row_connectionname = mysql_fetch_assoc($connectionname);
$totalRows_connectionname = mysql_num_rows($connectionname);

trying to do this.

row #1

field 1 = 50
field 2= person1

row #2

field 1 = 40
field 2= person2

row 3

field 1 = 100
field 2= person1

How can I query so I get this result.

Field 1 we are adding up all the numbers by person1

ie... field 1= 150 by person 1

Group them together

person 1 has 150

person 2 has 40

[LordShryku]

SELECT field1, sum(field2)
FROM table
GROUP BY field1

[bimmer528]

its not adding up the numbers in field 1

[LordShryku]

Had that backwards

SELECT field2, sum(field1)
FROM table
GROUP BY field2

[bimmer528]

yea its just not working..

SELECT name, sum(thenumbers) FROM table GROUP BY name

all i get is as the result are the names. thenumbers are blank.

[LordShryku]

What kind of field is it set to?

[bimmer528]

varchar, should I change to int?

[LordShryku]

yep. can't do math on a varchar unless you cast it.

[bimmer528]

Still no luck.

I changed the field thenumer to both tinyint and int, default=0, not null, no attributes, no extra.

I added some entries to the database manully to and its still not summing thenumbers.

[bimmer528]

i got it to work. I forgot to change my echo statement to the change in the query.

thx LordShryku