JSON format

[flex567]

hi,

I created a function that returns an id field and proverb field in mysql.
Right now my function returns this row:

1"The die is cast"

In xml format this would probably look like this

<ID>1<\ID>
<Proverb>"The die is cast"<\Proverb>

I would like to know how would this row look like in JSON fomrat?

[laserlight]

It would probably be:

{"ID": 1, "Proverb": "The die is cast"}

or if the double quotes are really part of the Proverb, then:

{"ID": 1, "Proverb": "\"The die is cast\""}

You should take a look at the syntax's description at json.org.

[flex567]

hm, i guess it is better that i remove double quotes in mysql database.