How to fetch unique names from columns ?

[ankur0101]

Hi,

I have table structure as follows :

 

Name            Amount

=================

John               500

John               300

John               200

Danny            250

Danny            250

=================

 

Now I want to fetch data according to follows :

 

John => 1000

Danny => 500

 

I tried lot of logics but nothing still working perfectly. I am using codeigniter. But if I will get PHP code to fetch like that, I can manage things in codeigniter.

 

 

Thanks

[mac_gyver]

SELECT Name, SUM(Amount) as amt FROM your_table GROUP BY Name