Re: PHP and using mysql_last_id()

[Lorderon]

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"" <elly.wisata@stripped> wrote in message
news:mysql.general-161925@ style="color:#666">stripped...
> Does php have a function like mysql_insert_id but support a zerofill auto
> increment int?
>
> ~Elle~
> -----Original Message-----
> From: jeffrey_n_Dyke@stripped [mailto:jeffrey_n_Dyke@stripped]
> Sent: Wednesday, March 17, 2004 5:19 AM
> To: mysql@stripped
> 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/mysql?unsub=1
>
>
>
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
>
>