Hi Paco,
If I could make a suggestion... I think you'll be much happier using a
newer version of perl than 4. With perl 5 and up you get to use the
wonderful features of DBI (Perl's database interface module) and DBD
(database drivers such as the one for Mysql). Not without saying you'll
get to use hundreds of other modules as well, including ones to help you
with your cgi interface.
Really, consider switching to Perl 5 or later...
Good Luck,
Michael
At 12:26 PM 11/2/2001 -0800, paco anubis wrote:
>Hello,
>I started learning Perl 4 weeks ago and mysql 3 days
>ago so I know that I am in over my head, but here goes
>nothing. I am trying to build a Perl CGI application
>(using DBI) to pass form contents from a web page
>directly into a MySql database.
> I don't know how to pass the Perl variable from the
>form into the database. I tried to assign the value
>using the following code (where "$feilds{user}" is the
>Perl variable to pass):
>
>$userdb=$dbh->($feilds{user});
>
>$rows=$dbh->do
> ("INSERT INTO bandbook (user, ect, ect...)
> VALUES ($userdb, 'ect', 'ect', ...)")
> || die "fucked up inserting data: $DBI::errstr";
>
>print "$rows row succesfully added to bandbook\n";
>
>
>As you may have guessed the table, bandbook is still
>empty because the script always dies. Can anyone point
>me in a better direction. Due to my unfamiliarity with
>either language, I am definately not ruling out a
>syntax error.
>Thank You,
>Paco
>
>__________________________________________________
>Do You Yahoo!?
>Find a job, post your resume.
>http://careers.yahoo.com
>
>---------------------------------------------------------------------
>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
---------------------------------------------------------------------
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
