Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Get the Last ID Assigned by MySQL
How To Get the Last ID Assigned by MySQL? - PHP Script Tips - Working with MySQL Database
✍: FYIcenter.com
If you use an ID column with AUTO_INCREMENT attribute, you can use the mysql_insert_id() function to get the last ID value assigned by the MySQL server, as shown in the sample script below:
<?php include "mysql_connection.php"; $sql = "INSERT INTO fyi_users (name) VALUES ('John King')"; if (mysql_query($sql, $con)) { print(mysql_affected_rows() . " rows inserted.\n"); print("Last ID inserted: ".mysql_insert_id()."\n"); } else { print("SQL statement failed.\n"); } mysql_close($con); ?>
If you run this script, you will get something like this:
1 rows inserted. Last ID inserted: 3
2007-04-18, 5296👍, 0💬
Popular Posts:
Can you tell me how to check whether a linked list is circular? Create two pointers, and set both to...
What Is Paint Shop Pro? - PSP Tutorials - Fading Images to Background Colors with PSP Paint Shop Pro...
How To Use an Array as a Queue? - PHP Script Tips - PHP Built-in Functions for Arrays A queue is a s...
How To Compare Two Strings with strcmp()? - PHP Script Tips - PHP Built-in Functions for Strings PHP...
Can each Java object keep track of all the threads that want to exclusively access to it?