I need urgent help representing grouped data in a table

[gibigbig]

Here is my database:

 

receipt_id      |      item_id      |      something_here

 

      21                          1                          2

      29                          1                          10

      30                          1                          3

      31                          2                          9

 

What i would like to do is display the above data from my database in a table looking like this:

 

receipt_id      |      item_id      |      total_something_here

 

      21                          1                          15

      31                          2                          9

 

 

in short, i want to show only different item_id with the sum of something_here field for all records where item_id is the same

 

ie 10 + 3 + 2 = 15

in the above example

please help me

 

[laffin]

SELECT item_id,SUM(price) AS total FROM reciepts GROUP BY item_id ORDER BY item_Id

[gibigbig]

not working

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in [path]/rpg.php on line 211

 

my table name is rpg_receipt

 

and the field i want the sum of is "amount_remaining"

i edited the query to fit mine and its not working.

 

SELECT item_id, SUM(amount_remaining) AS 'total'  FROM rpg_reciept GROUP BY item_id ORDER BY item_id  WHERE userid = '".$userid."' AND amount_remaining <> 'none'

[laffin]

The Where Clause comes before the GROUP and ORDER BY clause

SELECT item_id, SUM(amount_remaining) AS 'total'  FROM rpg_reciept WHERE userid = '".$userid."' AND amount_remaining <> 'none' GROUP BY item_id ORDER BY item_id  

[gibigbig]

still no luck

 

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in [path]/rpg.php on line 211

[gibigbig]

lol i just checked its working now, turns out i had spelt receipt wrong

i had reciept

 

thanks alot bro

it really means alot moving this project forward

/solved

[laffin]

Gratz