jquery - data to be given to plot on graph -


am using fushion charts. in data chart has been given folllows

   <script type="text/javascript"><!--                         var combidydata = '<chart     caption="weekly sales summary" subcaption="revenue & quantity" xaxisname="weeks"  pyaxisname="amount" syaxisname="quantity" numberprefix="$" placevaluesinside="1"> \n\                         <categories>\n\                             <category label="week1"/>\n\                             <category label="week2"/>\n\                             <category label="week3"/>\n\                             <category label="week4"/>\n\                             <category label="week5"/>\n\                             <category label="week6"/>\n\                         </categories>\n\                         <dataset seriesname="revenue">\n\                             <set  value="264000" /> \n\                             <set  value="346000" /> \n\                             <set  value="440000" /> \n\                             <set  value="267000" /> \n\                             <set  value="267000" /> \n\                             <set  value="267000" /> \n\                         </dataset>\n\                         <dataset seriesname="quantity" parentyaxis="s" showvalues="0"> \n\                             <set  value="1600" /> \n\                             <set  value="1900" /> \n\                             <set  value="2400" /> \n\                             <set  value="1600" /> \n\                             <set  value="1600" /> \n\                             <set  value="1600" /> \n\                         </dataset>\n\                         </chart>';   

how can same data database. please suggest me how can store in db , how retrieve inorder data in same way. thanks.

you looking type use store in database, if so:

longtext excessive -- allows data sizes 4gb.

mediumtext allows 16mb.

text allows 64kb.

tinytext allows 255 characters.

very few html documents going 64kb in size, text ought suitable you. if want safe, go mediumtext.

reference: http://dev.mysql.com/doc/refman/5.0/en/string-type-overview.html


Comments