mattichu Posted December 12, 2012 Share Posted December 12, 2012 Hi I have a table: ------------------------------------------------------------------------------------------ ID | DATE | Staff1 | Staff2 | Staff3 | venue | ------------------------------------------------------------------------------------------ 1 1st Jan 10-cl 11-cl OFF xx 2 2nd Jan 11-cl 10-cl 10-cl xx 3 3rd Jan 10-cl 11-cl OFF xx 4 4th Jan 11-cl 10-cl 10-cl xx 5 5th Jan 10-cl 11-cl OFF xx 6 6thJan 11-cl 10-cl 10-cl xy How would I swap the contents in staff 1 and 2 AFTER the 2nd jan? any help much appreciated! ^^ Link to comment https://forums.phpfreaks.com/topic/271913-copy-data-from-column-into-another-column/ Share on other sites More sharing options...
Pikachu2000 Posted December 12, 2012 Share Posted December 12, 2012 Let me get out my crystal ball. Link to comment https://forums.phpfreaks.com/topic/271913-copy-data-from-column-into-another-column/#findComment-1398935 Share on other sites More sharing options...
Jessica Posted December 12, 2012 Share Posted December 12, 2012 You need to normalize your data. Link to comment https://forums.phpfreaks.com/topic/271913-copy-data-from-column-into-another-column/#findComment-1398936 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.