Hi there.
I need to distribute equally these five names for the working weeks in the year, excluding saturday, sunday and holidays
I need table with weeks of the year?
Can you help me? Any suggestions?
thank you
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `tbl_names`
-- ----------------------------
DROP TABLE IF EXISTS `tbl_names`;
CREATE TABLE `tbl_names` (
`Names` varchar(50) DEFAULT NULL,
`id` int(10) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of tbl_names
-- ----------------------------
INSERT INTO `tbl_names` VALUES ('George', '1');
INSERT INTO `tbl_names` VALUES ('Laura', '2');
INSERT INTO `tbl_names` VALUES ('Martin', '3');
INSERT INTO `tbl_names` VALUES ('Arnold', '4');
INSERT INTO `tbl_names` VALUES ('Betty', '5');