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? 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() 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
Archived
This topic is now archived and is closed to further replies.