select the newest input

[ayok]

Hi,

I'm stuck in this case.

 

I have a form which will insert some data's to a database, and in the next script I need to select the "id" immediately.

Let's say I have this form:

<input type=text name=yourname>
<textarea name=msg></textarea>

 

After submit the form, it will insert the data's to mysql:

<?php mysql_query("INSERT INTO list(yourname,msg) VALUE('$yourname','$msg')")
.....?>

So for example a visitor fill in the form, name: John, msg: Hi, How are you?

This input will be inserted into the database as:

id      name      msg

3        John      Hi, How....

 

The problem is, how can I select the 'id' immediately in the same php page?

I've try "SELECT id FROM list ORDER BY id DESC". It works, but if someone else insert a new data, then the result is different.

 

ayok

[fenway]

LAST_INSERT_ID().