Clean upTable

[rusking]

SELECT TYPE,date , (Amount) FROM DEBITS where TYPE='Cell Phone' HAVING Date BETWEEN '1999-05-20 00:00:00' AND '2013-05-21 00:00:00'

Gives me :

 

Im trying to add all the 'Vaule' displayed. IF i SUM like this

SELECT TYPE,date , SUM(Amount) FROM DEBITS where TYPE='Cell Phone' HAVING Date BETWEEN '1999-05-20 00:00:00' AND '2013-05-21 00:00:00'

 I get:

 

 

 

 

This seems correct but if i chage the dates and sum:

SELECT TYPE,date , SUM(Amount) FROM DEBITS where TYPE='Cell Phone' HAVING Date BETWEEN '2012-05-20 00:00:00' AND '2013-05-21 00:00:00'

I return :

 

 

I am new to MySQLi and have been learning it the past 30 hours. Ultimately if i could add only the 'Vaule' of the proucted array i should be ok but i keep breaking it

Edited May 19, 2013 by rusking

[Barand]

At least make some attempt to make the outputs readable

[rusking]

fixed the outputs so they should be easier to read now

Edited May 19, 2013 by rusking

[Barand]

What output are you trying to get? You haven't said what your problem is, all you've done is tell us what you have tried.

[rusking]

It currently adds the amounts column if i use SUM. Im wanting it to when it narow the date, only add the amounts ('vaule') shown. The third returned image shows its still addin all teh amounts instead of teh selected dates. The first returned image shows every entry for reference

Edited May 19, 2013 by rusking

[Barand]

try

SELECT TYPE, SUM(Amount) as total 
FROM DEBITS 
WHERE TYPE='Cell Phone' 
AND DATE(Date) BETWEEN '2012-05-20' AND '2013-05-21'
GROUP BY TYPE

[rusking]

i think that solved it, thankyou very much

Edited May 19, 2013 by rusking