selecting differnt results from the same table.

[DataHugger]

Greetings,

I have am using mysql.

I wish to select from a table x number of result that match the same criteria then continue select that same x number that match the same criteria but differnt from the first criteria.

example table.

x = 2
medicine type
asprin I
tylenol I
advil II
creatin III
salvation R
Redemption R
painkiller I

results would look like

asprin I
tylenol I
advil II
creatin III
Salvation R
Remdemption R

It needs to go through the table selecting up to X and then continue on to the next possible value.

Does anyone have any suggestions?

-DaTaHuGGeR