Age based query

[jaymc]

I have a member database, and with that I have a members online list, heres the problem

 

If a member is over 18, I want to display members over 16 first, then when there are no more over 16's, show anyone else (14, 15 year olds etc)

 

So in other words there may be 23 pages of over 16's, then the 24th page will show 14 and 15 year olds

 

How can I make this into a query, as obvious "select * from members where age >= 16" will not show any under 16s on page 24..

 

Any ideas?

[waterssaz]

Yes but using the above will display all members who match that criteria. You can print those out to the screen. Then you can run another query for the 14-15 year olds and simply append that onto the end

[jaymc]

I am not displaying them in 1 big list, there will be 20 per page and 50 pages, thats why its a bit tricky

 

Any more ideas?

[waterssaz]

could you not just do a select on age descending or something?

[jaymc]

No, as I dont want it to show oldest first, needs to be pretty random rather than display 30 year olds on the first 4 pages when its an 18 year old viewing

[waterssaz]

ok no probs, obviously I'm not fully understanding what you are trying to do :-)

[jaymc]

lets say I have these ages

 

14,15,15,16,17,20,23,25,25,26,29,30

 

I want to display them something like this

 

23,17,30,16,26,25,25,20,15,14,15

 

In other words, any age under 16 can never come before an age 16 or over

 

I cant do a subquery because im not displaying all the results in one big list, they will be paginated

[fenway]

You just need to add another binary expression to check for the 18 restriction and all this to the order by.

[jaymc]

Can you give an example of what you mean fenway?

[fenway]

ORDER BY IF( age >= 16, 0, 1 ) ASC