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