Question

This question already has answers here:

Possible Duplicate:
PHP: how to get last inserted ID of a table?

我把我的我的我的我的我的我的我的我的我的我的我的我的我的我的我的我的我的我的我的我的我的我的我的我的我的我的我的我的我的我的我的我的我的我的我的我的我的我的我的我的我的我的我的我的我的我的我的我的卡。页: 1 缩略语

mysql_query("INSERT INTO tickets (Submitted, UNIXtime, Subject, Text, User, Priority, Status, Service) VALUES ( $date ,  $UNIXtime ,  $subject ,  $text ,  $userss ,  $priority ,  $status ,  $service )");

It then inserts an Id number in that row. How would I get that ID number so I can echo it out for example $id = (The ID number from that submit); echo $id;?

得到帮助。如果你能够的话,你能否重写这部法典,使之发挥作用,让我知道怎么做?

Answer 1

You re looking for mysql_insert_id(). This function will return the ID of the last query.

您在提出询问后可以打电话:

mysql_query( $insert_query );
echo "Last ID is " . mysql_insert_id();

Answer 2

You can use mysql_insert_id to get the last ID from the table. Note: You have to call mysql_insert_id right after the insert as it works only on the last executed query.

$id = mysql_insert_id();

Answer 3

mysql_insert_id(>;。

rel=“nofollow”http://dev.mysql.com/doc/refman/5.0/en/to-unique-id.html

//Example
$id = mysql_insert_id(); 
echo $id;

Answer 4

rel=“nofollow”>mysql_insert_id(

友情链接