Jamie T

Members
  • Content count

    3
  • Joined

  • Last visited

Everything posted by Jamie T

  1. Plotting with varchar

    Hello All. I'm trying to plot my inventory ..... stocktype (eg. Bearings, Motors etc) against quantity (from the same table), but the chart won't plot. I think it's because the chart only works with numbers. Is this true? So how can I plot how many bearings and motors I have without creating another table etc.? Thanks. Jamie.
  2. Plotting with varchar

    Thanks Arindam. The XML structure you've given me is a static XML page. I'm trying to plot dynamically from a database table. I've done the SQL and it is plotting with the base line (catag) values as numbers (1,2,3 etc), but if I change these values to words (bearings, motors etc) then it won't return data to plot. Any ideas what I'm doing wrong. I appreciate how frustrating it must be trying to guide people who don't know what they're doing but I've been struggling with this for 2 weeks now. Your help is much appreciated while I build an evaluation of your product. Jamie.
  3. Plotting with varchar

    Thanks for the quick response. I'm plotting from a database with MySql/PHP. My table looks similar to this: PartNumber catagory quantity 1 bearing 4 2 bearing 5 3 bearing 15 4 motor 2 5 motor 6 6 belt 2 7 belt 5 I want a simple graph to show total quantities for each catagory. I can do it if catagory was a number, but not as a word. Can you help? Thanks. Jamie.