Send to a Friend

frankielaguna's avatar

MySQL Sort by every other row?

Asked by frankielaguna (256points) June 10th, 2009

Okay so I’ve run into a road block here and I need some help..

Thanks!

I have a table with a name and sex field.

I need sort this table by sex but it needs to be every other row.

In other words..

M
F
M
F

etc..

I’ve been trying to think of a PHP solution for it but what I came up with didn’t work quite right..

Does anyone have any suggestions on how I may accomplish this in PHP or SQL?

Using Fluther

or

Using Email

Separate multiple emails with commas.
We’ll only use these emails for this message.