You have two quotes after 'email'.
Todd Marks wrote:
> hello,
> just want to start off saying that I am a complete newbie to mysql-sorry. I
>have a perl script that I am simply trying to dump three variables(name CHAR(30),
>email(50), and score INT) to a database table that has already been established.
>having some difficulty and wanted to post this to see if everything jives or I am a
>complete boob.
> -t.
>
> #!/usr/bin/perl -w
>
> use strict;
> use CGI qw(:standard);
> use DBI;
>
> # change undef(s) to username and password if required
> my $dbh->connect('DBI:mysql:afp', undef, undef);
>
> my $sth=$dbh->prepare("
> INSERT INTO afp
> VALUES (?,?,?)
> ");
>
> $sth->execute('name','email'', '0'') || die "execute insert failed";
> $sth->finish();
> .............................................
> [EMAIL PROTECTED]
> research and development
> www.digitalorganism.com
> t. (410) 342 - 1162
> f. (410) 342 - 1164
> .............................................
--
Gerald L. Clark
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
