did you mean you need help with an sql query for this? sounds like
select id, group, name from MYTABLE order by group; since i cant read your mind and you didnt specify anything else and since this is a php-db mailing list, hope that's what you are asking for... of course i could me a mile off... [EMAIL PROTECTED] wrote: > Hi.. > > I need to get 2 groups of random result with 1 group always on top of the > other. > Can anyone help me with this please.. > > Something like > > id | group | name > 2 1 john > 5 1 smith > 32 1 sara > 12 1 michael > 1 2 don > 9 2 beth > 4 2 bob > > -- Leo G. Divinagracia III [EMAIL PROTECTED] -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
