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

guessing the query did not work

Don't guess, test for errors. Or, even better, make DBI do that for you:

my $dbh=DBI->connect($dsn,$user,$password,{ RaiseError => 1, ... });

[download]

Alexander

--
Today I will gladly share my knowledge and experience, for there are no sweeter words than "I told you so". ;-)

Replies are listed 'Best First'.
Re^4: Getting mysql data into gd
by shanta (Novice) on Sep 03, 2017 at 16:31 UTC
    Thanks This failed with the ... had to remove. dose report all dbi errors or just connect?
[reply]
Re^4: Getting mysql data into gd
by shanta (Novice) on Sep 03, 2017 at 16:59 UTC

    Tried that code but it failed had to remove ', ...' to make it work.

    Dose this way of requesting and error work for all errors or just connect? As it is in connect.

[reply]

      shanta:

      The RaiseError=>1 part is telling DBI to raise an error whenever it sees one. The ", ..." part just meant that you would put in any other connect parameters you currently use.

      ...roboticus

      When your only tool is a hammer, all problems look like your thumb.

[reply]
[d/l]

        Thanks for the explanation.

[reply]

In Section Seekers of Perl Wisdom