in reply to Re^2: Getting mysql data into gd
in thread Getting mysql data into gd

Hello shanta,

It looks like the data that you are trying to export from the DB they are not populated. At this point without any sample of data and sample of DB table we can only assume that the SELECT function is not populating the data.

If I was you I would follow the advice of fellow monk marinersk, you need to debug step by step your connection to the DB and that you are actually retrieving the expected data. As soon you have reached this point and you are sure that all the mandatory steps are met then make sure the data that you are providing to GD::Graph::Data are the ones that it expects.

Sample of expected data taken from the GD::Graph::Data/DESCRIPTION:

An object of this class contains a list of X values, and a number of l
+ists of corresponding Y values. This only really makes sense if the Y
+ values are numerical, but you can basically store anything.

[download]

Make sure that the data that you are trying to push into the Graph are as described by the DESCRIPTION.

Hope this helps, BR.

Seeking for Perl wisdom...on the process of learning...not there...yet!

Replies are listed 'Best First'.
Re^4: Getting mysql data into gd
by shanta (Novice) on Sep 03, 2017 at 16:44 UTC

    Got things down to the query 

    my $batchnumber = $CGI ->param('batchnumber')||"20170903nervana" ;

my $sql = "SELECT time, mastuntemp, LineTemp, spargtemp FROM brew_temp
+_tb WHERE sitename = 'Brew' AND batchnumber = '$batchnumber' ORDER BY
time";

    [download]

    There is data in the database. Which I display in ttml

[reply]
[d/l]

In Section Seekers of Perl Wisdom