RE: Multi-Series with MySQL Database :: URGENT!

karenn1 — Wed, 09 Apr 2008 02:26:49 GMT

Hi Pallav,

I had look at my data and there were commas in it. I've taken it out and now it works fine. Thank you for that insight! My other question though, my table of data (as I posted in my first post above) is very lob-sided. Is there an easier way to structure my table?

Thanks!
Karen

RE: Multi-Series with MySQL Database :: URGENT!

Pallav — Tue, 08 Apr 2008 22:26:08 GMT

Is your data in XML purely numeric - without any currency or comma signs?

RE: Multi-Series with MySQL Database :: URGENT!

karenn1 — Mon, 07 Apr 2008 00:48:33 GMT

Hi,

Thanks for your reply. I've changed the code as you requested and this is what I get:

At least it's picking up on all four stations per month but it's not recognizing the units. Any insight why this could be?

Thanks!
Karen

RE: Multi-Series with MySQL Database :: URGENT!

Sudipto Choudhury — Mon, 07 Apr 2008 00:15:02 GMT

Hi,

Could you please try changin the SQL :

$strQuery = "select units, months, stationName from stations_new ORDER BY stationName";

Multi-Series with MySQL Database :: URGENT!

karenn1 — Fri, 04 Apr 2008 05:28:27 GMT

Can anyone urgently help me please? I want to use the multi-series option of FusionCharts and connect it to my database. This is what my table looks like:

[code]
months units stationName

January	14,629	Station 1
February	19,161	Station 1
March	13,388	Station 1
April	10,522	Station 1
May	15,941	Station 1
June	10,650	Station 1
July	11,005	Station 1
August	19,141	Station 1
September	13,228	Station 1
October	22,452	Station 1
November	15,757	Station 1
December	20,464	Station 1
January	15,654	Station 2
February	16,718	Station 2
March	14,839	Station 2
April	12,791	Station 2
May	12,838	Station 2
June	14,229	Station 2
July	15,616	Station 2
August	14,633	Station 2
September	19,544	Station 2
October	16,592	Station 2
November	14,746	Station 2
December	15,425	Station 2
January	233,796	Station 3
February	82,309	Station 3
March	198,876	Station 3
April	34,959	Station 3
May	367,101	Station 3
June	430,691	Station 3
July	220,664	Station 3
August	318,963	Station 3
September	106,403	Station 3
October	248,531	Station 3
November	339,486	Station 3
December	174,552	Station 3
January	190,048	Station 4
February	38,460	Station 4
March	178,998	Station 4
April	49,516	Station 4
May	256,988	Station 4
June	307,099	Station 4
July	201,678	Station 4
August	215,608	Station 4
September	108,847	Station 4
October	222,191	Station 4
November	235,785	Station 4
December	103,880	Station 4

[/code]

I'm struggling to get the info from the table. Here's PHP the code I used:

[code]

# Months

$strQuery = "SELECT distinct months FROM stations_new";
$result = mysql_query($strQuery);

# Add category names
$FC->addCategoryFromDatabase($result, "months");

# Stations

# Create a new dataset

$strQuery = "select units, months, stationName from stations_new GROUP BY stationName";
$result = mysql_query($strQuery);
$FC->addDatasetsFromDatabase($result, "stationName", "units");

# Add chart values for the above dataset

$strQuery = "select months, units, stationName from stations_new";
$result = mysql_query($strQuery);
$FC->addDataFromDatabase($result, "units");

[/code]

This code is not working at all. What am I doing wrong? Is there anyway to simplify the table structure? The table above is very cumbersome. Eventually I would need it to be by week and days of the year. To do that the table would be 365 x 4 rows long. Is there a better way to do this?

Thanks!

Karen

FusionCharts Forum / FusionCharts Free / FusionCharts Free and PHP / Multi-Series with MySQL Database :: URGENT! / Latest Posts

RE: Multi-Series with MySQL Database :: URGENT!

RE: Multi-Series with MySQL Database :: URGENT!

RE: Multi-Series with MySQL Database :: URGENT!

RE: Multi-Series with MySQL Database :: URGENT!

Multi-Series with MySQL Database :: URGENT!