bender

Hi all, I'm doing graphs using php and Access. But my graph load very slowly and at last it displays the following message: "A script in this movie is causing Adobe Flash Player 9 to run slowly. If it continues to run, your computer may become unresponsive. Do you want to abort the script?" i want to know is there any way to prevent this problem? Please reply. Thanks.

I'm using ScrollCombiDY2D.. My data from the database is a lot...I guess that's the problem?

hello all, I want to know: does fusioncharts offer the option to make a XY line graph? it will look like this (i did this on excel) thanks

Hello, thanks for the reply. Can I use the Scatter graph, but then connect the points to make it look like they're connected by a line? If yes, can you show me an example of how to do it? thanks

thanks Arindam.. I checked the query of selecting the dates in Access and copied them into my code and it worked well...thanks again for helping me

Hi again everyone.. I want the users of my website to be able to select data for the graph to display only 1 year, 3 years or 5 years. So I went to select the date using date() and strtotime function in php... I tested it with my database by selecting this month's data, but it says 'No Data To Display'. I don't know what is wrong...can you help me? My codes is in attachment.. thanks in advance! testing.txt

ok here it is.. generated.txt

Hi Arindam, I tried that, but still no graph displayed...do you know what else is wrong?

hi everybody! can anyone help me with this? i have an MS Access database which have a lot of blanks with no values in the 'dams water levels'... so i'm wondering, whether i can show in my line graph that there is no reading on certain dates..eg: the line looks 'broken' for some period, then the line appears again when there's reading on that date. please help me if anyone knows how...i attached my codes for everyone to see and tell me what to do...thanks a lot in advance! mygraph.txt

Dear Arindam, I have another inquiry, hope you don't mind.. my data are dams level reading according to dates. the dates are plenty and up until now and for future use too. The prob is, I dont want my x- axis to clutter with dates, so I tried just labelling x axis and remove the 'category label' part, but now the anchor values do not display the date too! how can i modify it to be just the x-axis category labels gone, but the value of date in anchor is still there? I can attach a pic of my graph if you want, so you can have a better understanding on how to help me...thanks! reply to me..

Thank you so much, Arindam!! What you suggested really solved my problem I didn't know that we don't have to iterate thru each result...coz I followed the docs closely and it states that you have to iterate! Thank you so much again!

I've already checked my code and I'm sure I added the connectNullData='1' correctly...but there's error

Hi Rahul, hmm I did not find anything different between your code and my code...are you sure it is the right file?

hi Rahul, thanks for helping me... but i got this error after I changed that: Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '[PTP-1]='., SQL state 37000 in SQLExecDirect in C:wampwwwJPS Projektestptp2.php on line 58 37000 do you know what's wrong?

hi everyone! i was looking at the fusioncharts website and I noticed that you can create a discontinous data line graph (no data in the middle). I was wondering if i can do this dynamically with data from my database? coz in the example, it is in XML and the data is fixed. my database have several blank data in it and this database will be updated frequently in the future. is there any way to do discontinuous data graph with data from database? if yes, how do you code it? thanks very much...hope someone will help me on this.

Mick, I'm actually an undergrad student undergoing my practical in a software house..so it is my first time coding in php. My company is small and the programmer had quit recently, so I have to take over her job ENTIRELY! what am i to do, I'm just a practical student, and I do not have any clue about what they want me to do...lol on top of that they just pay me RM150...which is around $40-$50 a month! Soo... I will try and google it...hopefully there will be answers to my questions there...

hi everyone! this is just a simple question...hope someone will help me...hehe my x-axis display dates, but it appears with the time also.. eg: 1995-03-01 00:00:00 how to make it hide the time? in my database, I did not specify the time, just the date. Thanks.

hi Arindam, it worked! thank you very much! have a nice day

hi Arindam...thanks for teaching me... i tried inserting that code into my coding...but i could not get it to work. I don't know where to put it specifically...can you please tell me where to include that query? sorry, i'm still learning..I thank you very much for teaching me! below is my code, please do check and see where in the code should i include the query. thanks again! mycode.txt

hi mick! thanks for replying... i'm a newbie in programming, hehe so I don't really know how to manipulate the XML to be anything I want..i'm using php, btw and if you can tell me how to do this in php, it would be great.. thanks again and I'm waiting for ur reply!

anybody get any ideas on how to do this???

hello??? anybody got any ideas??? help me please....:crying:

i'm using MS ACCESS...

thanks for the reply... but how do you format the date? can you give some example code? sorry, i'm a total newbie...

Hi everybody! I have a problem...my code seems to have this Access error..I've checked many times but I can't find what's wrong with it... This is the error I get: Warning: odbc_exec() [function.odbc-exec]: SQL error: [Microsoft][ODBC Microsoft Access Driver] Syntax error in FROM clause., SQL state 37000 in SQLExecDirect in C:wampwwwJPS Projekel69.php on line 43 37000 Can somebody help me identify the error? I attached my code below if you wanna see it...thanks so much in advance! graphprob.txt