When i run this query with xml i get the desired result but when i run it with json i only get part of the result, why is there a difference?
select * from html where url="http://www.onemanga.com/Ii_Hito/" and xpath='//*[@id="content-side"]/div/div/div/p'
This is because there is no easy way to associate the text elements between XML and JSON. We've discussed this problem before and the best solution today is to use the hybrid version where you ask for JSON in XML format
All you have to do is issue the query with an additional query parameter called callback ensuring that the format parameter is set to 'xml'. THis gets you back the XML data in the JSON envelope which you can then directly add to your webpage by setting innerhtml