Re: Getting last record ID created from DB

On Mar 16, 2007, at 10:28 PM, Jeff wrote:

Is there a way to get the last Record # created by the DB. Example: User_ID = auto_increment f_name = varchar l_name = varchar e-mail = varchar b_date = varchar pic = varchar Since user_id is an auto_inc field I submit it as a NULL, also I haven't started the code for a picture yet either so I have it set to NULL at this moment. My code is: $query = "INSERT INTO t_users (user_id, f_name, l_name, e_mail, b_date, pic) VALUES ('', '$f_name', '$l_name', '$e_mail', '$b_date', '')"; $result = mysql_query($query); if(!$result) { die("Could not query the database: <br/>".mysql_error()); } echo "Your Player information has been stored OK.<br />"; what code could I add here to make the following line work? echo "REMEMBER your USER ID# you will need it when creating Characters!! It is: $user_id"; <----- I want to show the "user_id" just created here. Thanks in advance!

For auto increment values, you don't have to specify the id. For example: INSERT INTO t_users (f_name, l_name, e_mail, b_date, pic) VALUES ('$f_name', '$l_name', '$e_mail', '$b_date', null); Then to find the latest entry: SELECT user_id FROM t_users ORDER BY user_id DESC limit 1; Hope that helps. ~Philip