Query to json

Query to json - HELP

El Forum
Guest

05-01-2012, 10:44 AM

[eluser]Near[/eluser]
Hi! I have a table named product containing this value
p_id | p_name | p_quantity
1 p1 10
2 p2 20
3 p1 5
4 p1 6

how would i get the records like this?

p1 [10,5,6]
p2 [20]

and then convert it to json.. Thanks!

Messages In This Thread

Query to json - HELP - by El Forum - 05-01-2012, 10:44 AM

Query to json - HELP - by El Forum - 05-01-2012, 11:22 AM

Query to json - HELP - by El Forum - 05-01-2012, 11:27 AM

Query to json - HELP - by El Forum - 05-01-2012, 11:37 AM