Re: Voting script using MySQL and DBI

[greywolf]

in reply to Voting script using MySQL and DBI

You might want to replace your $sth->execute() with the following:
    unless ($sth->execute()) { die $dbh->errstr() }
This will give you an error if your sql statement is bad for some reason.

If you're not already doing it try:
    use CGI::Carp qw(fatalsToBrowser);
This will send all your errors to the browser. Remember to remove this line before the script goes live.

mr greywolf

[lagrenouille]

G'day greywolf

ok thanks, i'll try that...
( I know the mySQL commands are good, I tested them from the shell by copying and pasting, worked fine... )

I know about CGI::carp, I am using the script in an SSI situation and to have huge error messages printed out disturbs the tables a lot and is hard to read... so i've just been reading it out of the server logs

Thanks for your help!

Cheers
lagrenouille