> Whatever you have suggested so far hasn't worked. I thought that
> maybe something
> is missing in my stating the problem and implementing your
> suggested solutions.
> So here is a more expanded picture of the queries:
>
> $sth=$dbh->prepare("INSERT INTO TABLE1 (id,var1,var2) VALUES (?,?,?)");
> $sth->execute("",$var1,$var2);
> $sth=$dbh->prepare("SELECT \@t1id:=LAST_INSERT_ID()");
> $sth->execute();
After this, try the following:
$sth2 = $dbh->prepare("SELECT \@t1id");
$sth2->execute();
$tmp = $sth2->fetchrow_arrayref();
print "ID: " . $tmp->[0];
See if you're getting a number here or not...
> $sth=$dbh->prepare("INSERT INTO TABLE1A (Aid,id,var1) VALUES (?,
> @t1id, $var1);
Note that using @t1id in double-quotes without escaping the @ will *never*
work, because Perl will think you are trying to use a Perl variable, when in
reality @t1id is a MySQL variable.
> $sth->execute("","",$var1);
Why are you sending unused bound parameters?
Try this:
$sth = $dbh->prepare("INSERT INTO TABLE1A (Aid,id,var1) VALUES (0, \@t1id,
$var1);
$sth->execute();
-JF
---------------------------------------------------------------------
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
