Taking a value from json array using jquery

Question

$.getJSON("./data/revenue-item-data.php",{val:'val'},function(data){

 $('#totalUnits').val(data[0].SUM(item_qty));
     $('#totalAmounts').val(data[0].SUM(DISTINCT net_total));


 });

Here is array I get for above code:

 [{"SUM(item_qty)":"68","SUM(DISTINCT net_total)":"42753"}]

How to display these 2 values (68 , 42753) in #totalUnits & #totalAmounts.This code does not display any thing.

codef0rmer · Accepted Answer · 2012-03-24 06:29:54Z

2

You can not call data[0].SUM(item_qty) as it treats SUM as a method. Try this.

data[0]['SUM(DISTINCT net_total)']

answered Mar 24, 2012 at 6:29

codef0rmer

10.5k9 gold badges55 silver badges78 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Wasim · Accepted Answer · 2012-03-24 06:29:40Z

1

$('#totalUnits').val(data["SUM(item_qty)"]);
$('#totalAmounts').val(data["SUM(DISTINCT net_total)"]);

answered Mar 24, 2012 at 6:29

Wasim

8967 silver badges24 bronze badges

Collectives™ on Stack Overflow

Taking a value from json array using jquery

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related