Working weeks in the year

[cms9651]

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');

[r937]

I need table with weeks of the year?

i think so, yes

but perhaps you could explain what you're doing so we understand it better

[cms9651]

thanks for the reply.

I should check that the the number weeks of work for the five names is the same for all... that is, there can not be a person who works more or less of other...