> Woops sorry about that last message.
> Try using the following:
> my $id = $sth->{insertid};
> That is what I had to change it to, to get it working.. despite what the
> documentation says.
Actually, I can't use that. The script dies, it's not like it just warns me
that it doesn't work, but it actually stops executing when it reaches that
statement.
I just do something like:
$id = $sh->{mysql_insertid};
$sh->finish;
if ($id < 1) {
$sh = $dbh->prepare('SELECT MAX(id) FROM myTable');
...
($id) = $sh->fetchrow;
...
}
It just seems a little silly to have to do this.
-Chris
> GL.
>
> ryan
>
>>> My ISP recently updated one of their servers to 3.23.38, and all of a
>> sudden
>>> a BUNCH of my code stopped working. I use a number of insert queries
>> (new
>>> items, new search caches, etc), where I insert a blank record, and then
>> take
>>> notes of its id (usually "int unsigned auto_increment primary key"), to
> be
>>> used in a subsequent UPDATE statement (or INSERT, to a related table).
>>>
>
>
>
> ---------------------------------------------------------------------
> 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
