Gavin Laking wrote:
>
> 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/Hi Gavin. You can't call a table 'table'. Call it 'mytable' or, preferably, something more descriptive. HTH, Rob -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
