trying to use sum()

[scmeeker]

I would like to use the SUM() to add up the column 'item_fee' under the current WHERE conditions and am not having any luck.  Keeps coming up blank but when I remove the SUM() it shows just one.

 

Here is the code I'm using:

 

$get_item_sql = "SELECT id, image_upload_box, title, username, date, price, SUM(item_fee) FROM product WHERE MONTH(date) = MONTH(CURDATE()) AND username = '".$_GET["username"]."'";

 

Any suggestions?  Thanks.

[fenway]

My guess is that you didn't alias your expression, and you're asking for the value back from a hash.