Liquid Fire Posted June 30, 2007 Share Posted June 30, 2007 Ok here is the problem, I am creating a system and i need to log any action that is done to the database in a table called log. The table with just hold the table_name, the user_id, and the table_id on the record add/editted/deleted. Now logging when I editted or delete if easy since the id already exist. I need to find out how to get the id(every table's primary key is called id) right after it is create so that whne I use my insert_array function on my mysql class, it return the id on the created entry so i can log the creation of whatever. anyone know how to do that? Quote Link to comment https://forums.phpfreaks.com/topic/57842-getting-the-primaray-id-after-creation/ Share on other sites More sharing options...
Wildbug Posted June 30, 2007 Share Posted June 30, 2007 In MySQL: LAST_INSERT_ID() In PHP: mysql_insert_id() Quote Link to comment https://forums.phpfreaks.com/topic/57842-getting-the-primaray-id-after-creation/#findComment-286595 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.