Getting value from mysql result array

Question

I'm having problem getting a value from array contains json. Here is the JSON i'm getting (printed by console.log(rows[0]) ) :

[ { User_ID: 28,
    Email: '[email protected]'} ]

But when trying to print the User_ID or Email:

console.log(rows[0].User_ID)

The output is undefined.

What am I doing wrong ?

Have you parsed the JSON data already?

Broxzier
– Broxzier

2013-09-30 13:51:41 +00:00
Commented Sep 30, 2013 at 13:51 — Broxzier
– Broxzier, Commented Sep 30, 2013 at 13:51

Bucket · Accepted Answer · 2013-09-30 14:00:28Z

2

If that's what you get after executing console.log(rows[0]), then you have another array to deal with. This should do the trick:

console.log(rows[0][0].User_ID); //28

Reason being, rows[0] returns an array, so once again you need to select the appropriate index from that returned value: rows[0][0]. This will give you the object you want.

edited Sep 30, 2013 at 14:00

answered Sep 30, 2013 at 13:53

Bucket

7,5599 gold badges38 silver badges48 bronze badges

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

Comments

Musa · Accepted Answer · 2013-09-30 13:53:08Z

1

rows[0] looks like an array. Try,

console.log(rows[0][0].User_ID)

answered Sep 30, 2013 at 13:53

Musa

97.9k17 gold badges123 silver badges144 bronze badges

Collectives™ on Stack Overflow

Getting value from mysql result array

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