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? - MySQL FAQs - Managing Tables and Running Queries with PHP Scripts
✍: 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-05-11, 7112👍, 0💬
Popular Posts:
I am trying to assign a variable the value of 0123, but it keeps coming up with a different number, ...
How does ASP.NET maintain state in between subsequent request ? Refer caching chapter.
How To Retrieve the Count of Updated Rows? - Oracle DBA FAQ - Working with Database Objects in PL/SQ...
How do we assign page specific attributes ? Page attributes are specified using the @Page directive.
Can we have static indexer in C# ? No.