Hi.
You know, mysql_insert_id returns a 64 bit integer (see
http://www.mysql.com/doc/m/y/mysql_insert_id.html)? Though, ignoring
this, you should normally get a steady 0 returned.
Another possible cause of failure could be that you did not recompile
your application and therefore have a version mismatch between the
includes you used and the dynamic libraries you use. In this case, try
a compile from scratch and see if it helps.
Bye,
Benjamin.
On Mon, Oct 01, 2001 at 11:34:29AM +0200, [EMAIL PROTECTED] wrote:
> Hello
>
> Firstly, this is my first query, so I can only hope I have sent it to the
> correct list!
>
> I am using the C API for MySQL, and using the mysql_insert_id() function to
> get the last id assigned in an AUTO INCREMENT column. Orignially I was using
> 3.22.32 and everything worked fine. Upon upgrading to 3.23.35 the call to
> mysql_insert_id(MYSQL*) returned the same value for every call. Each time a
> new connection is made, this value seems to increase (e.g it will be 14,
> then make a new connection, then it is 15 for that session...)
>
> I am sure I am reading the documenation correctly, but can't seem to find
> what is wrong. Any help with this problem (or my reading ability!) would be
> greatly appreciated.
>
> Thank you
> Matthew Fincham
>
--
[EMAIL PROTECTED]
---------------------------------------------------------------------
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
