in reply to INSERT Problem

You'd better go check your logs to see what the script is complaining about (I bet there's some useful info in there ;-)

I would slightly alter your code though, using placeholders (and die with the error message):

$sth = $dbh->prepare("INSERT INTO email (f_name, l_name, code, ext, em +ail) VALUES (?,?,?,?,?)"); $sth->execute($FNAME, $LNAME, $STR, $CT5, $EMAIL) || die $sth->errstr;

And don't forget we have some nice Tutorials on DBI related subjects :)

--
b10m

All code is usually tested, but rarely trusted.

Replies are listed 'Best First'.
Re: Re: INSERT Problem
by Anonymous Monk on Apr 28, 2004 at 19:50 UTC
    Still doesn't work I am reading from two different DB and while I am reading from the first DB I am inserting the data into the other table in another DB.
      please show your 'new' attempt