Select Sum and Undefined Property Issue

Register Sign In

Select Sum and Undefined Property Issue

El Forum
Guest

#3

03-02-2008, 09:06 AM

[eluser]blupixelz[/eluser]
When I run the SQL statement in phpMyAdmin, I only get one row as a result

MySQL Query

Code:
SELECT SUM(price) AS 'total_price' FROM movies

WHERE year(date_added) = '2007'

Result

Code:
total_price

50.00

I'm still puzzled by this... considering how simple the query is...

Messages In This Thread

Select Sum and Undefined Property Issue - by El Forum - 03-02-2008, 08:53 AM

Select Sum and Undefined Property Issue - by El Forum - 03-02-2008, 08:58 AM

Select Sum and Undefined Property Issue - by El Forum - 03-02-2008, 09:06 AM

Select Sum and Undefined Property Issue - by El Forum - 03-02-2008, 09:08 AM

Select Sum and Undefined Property Issue - by El Forum - 03-02-2008, 09:21 AM

Select Sum and Undefined Property Issue - by El Forum - 03-02-2008, 09:26 AM

Select Sum and Undefined Property Issue - by El Forum - 03-02-2008, 09:53 AM

Select Sum and Undefined Property Issue - by El Forum - 05-08-2012, 04:04 AM

Select Sum and Undefined Property Issue - by El Forum - 05-08-2012, 05:02 AM

Theme © iAndrew 2016 - Forum software by © MyBB