First, sorry for the wrap on the lines below. I am trying to insert some values into a mySQL database, all of the scalars below have a value (none are undefined). I keep getting errors similar to the one below and despite being instructed to read the mySQL manual, I cannot find anything that relates to the problem I'm experiencing.
Is the problem with my Perl (likely), or mySQL? Can anyone offer a solution or pointers towards possible solutions?
Thank you in advance for any help you may be able to provide.
CODE:
my $dbh = DBI->connect("DBI:mysql:database","username","password");
my $result = $dbh->prepare("INSERT INTO table( sitename,siteurl,category,description,country,region,city,added,expires,submitted) VALUES (?,?,?,?,?,?,?,?,?,?)");
$result->execute($sitename,$siteurl,$category,$description,$country,$region,$city,$added,$expires,$submitted);
print $dbh->errstr(),"\n" unless ($result);
$dbh->disconnect();
ERROR:
DBD::mysql::st execute failed: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near database(sitename,siteurl,category,description,country,region, at /home/gl/httpd/index.pl line 403., referer: http://gl.example.com/
-- Gavin Laking
http://www.gavinlaking.co.uk/ --
-- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
