----- Original Message -----
From: "Gavin Laking" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, September 10, 2003 8:41 AM
Subject: mysql and dbi
> Hi,
>
> 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,subm
itted)
> 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
HI
'table' is a mySQL reserved word; see:
http://www.mysql.com/doc/en/Reserved_words.html
Your insert statment seems to be trying to insert into
a table named table - a NO NO.
Aloha -> Beau;
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
