Posted by Rik on 07/20/07 07:56

On Fri, 20 Jul 2007 09:44:24 +0200, newbie <mitbbsmj@yahoo.com> wrote:

> I am writing a DB like this:
> ---------------------------------------------------------------------
> | id (auto_incremented filed) | foo | bar |
> ---------------------------------------------------------------------
>
> $sql_query =3D "INSERT INTO `table` (`foo`, `bar`) VALUES ('$string_1'=
,
> '$string_2')";
> mysql_query($sql_query, $db_handle);
> //how can I get id for the above inserted entry? is that possible I
> get it with a single mysql instruction?
>
>
> since each time I write a record into mysql, 'id' is incremented,
> how can I get the id that an insertion corresponds to (can I get it
> with a single mysql instruction)?

PHP:
mysql_insert_id();
MySQL:
mysql_query('SELECT LAST_INSERT_ID()');


-- =

Rik Wasmus

• Next in forum: Re: Creating an array from an HTML table
• Prev in forum: can this be achieved by a single mysql instruction?
• Thread view: Re: can this be achieved by a single mysql instruction?

[Reply to this message]