At 14:07 -0700 2/6/02, Nathan Bank wrote:
>Though this is a PHP issue, for those that use PHP here's what was
>wrong: mysql_insert_id() requires
>your connection link identifier, which is what is returned from
>mysql_connect and mysql_pconnect.
>This is contrary to almost all other mysql_ functions, which want
>the result resource returned from
>your query.
I guess that's one way to look at it.
Another way is that mysql_insert_id() is consistent with all the other
mysql_ functions in that it requires arguments that are appropriate for
the type of information you're requesting. :-)
In this particular case, the insert-id is maintained on a connection-specific
basis, so it would be strange for it to require a result resource rather than
a connection identifier.
>Hope this saves a few people some agony.
>
># Nathan