phpjay Posted July 9, 2011 Share Posted July 9, 2011 hi to every one is it possible to insert a data from selected ID example if have 2 tables 1 is for employee and 1 is for status and i want to insert a status in selected ID from employee after that the following day i will insert again a data from the selected ID Quote Link to comment https://forums.phpfreaks.com/topic/241476-insert-and-insert-with-specific-table/ Share on other sites More sharing options...
gizmola Posted July 9, 2011 Share Posted July 9, 2011 Yes it is possible. The simplest way is to have the status table have a structure like this: Status ------------- status_id (int, pk, auto_increment) employee_id status created_on timestamp Quote Link to comment https://forums.phpfreaks.com/topic/241476-insert-and-insert-with-specific-table/#findComment-1240414 Share on other sites More sharing options...
phpjay Posted July 9, 2011 Author Share Posted July 9, 2011 thanks i already have it.. Quote Link to comment https://forums.phpfreaks.com/topic/241476-insert-and-insert-with-specific-table/#findComment-1240418 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.