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

[Barand]

At least make some attempt to make the outputs readable

[rusking]

fixed the outputs so they should be easier to read now

[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

[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