This question is basically similar to SoulieBaby's question here:[Split MYSQL results into 4 arrays](https://stackoverflow.com/questions/1237011/split-mysql-results-into-4-arrays), except that I wanted to split the result to contain a specific length.

Say, I wanted the result of an array which has a length of 9 to be splitted and have the splitted array to contain 5 lengths. So first array will have 5 and second will have 4.

Is this possible?

Thanks so much for any help!