It is better run a query with:
SELECT LAST_INSERT_ID();
immediately after making the insert query. that way you'll get the exact
ID..
""Elly Wisata"" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Does php have a function like mysql_insert_id but support a zerofill auto
> increment int?
>
> ~Elle~
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, March 17, 2004 5:19 AM
> To: [EMAIL PROTECTED]
> Subject: Re: PHP and using mysql_last_id()
>
>
>
> Hi can anyone tell me how to use php's mysql_last_id() or MySQL's
> INSERT_LAST_ID
>
> -------------
> php's function is mysql_insert_id() and not mysql_last_id(), there is no
> php function called mysql_last_id()...if you saw that in a manual, i'd
> email the owner of the document.
>
>
> http://php.net/mysql_insert_id
> hth
> Jeff
> _____________
>
> I have a page registration page, using a username, password and member
> level
> text box.
>
> I want to send the user (upon successful insert) to a member's detail form
> where the password table primary key is avaliable it can be kept and
> entered
> to subsequent tables as a Foriegn Key.
>
> But when I have tried it all I ever get is a value of "1".
>
> I have looked at the manuals online and found a couple of books that list
> these functions, and understand the syntax qnd what it does,
>
> but can not find a working example or inducation as to where it goes etc
>
> any pointers would be much appreciated
>
> stu
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
>
>
>
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
