Re: 2 groups of random result pls help...
| From: | leo g. divinagracia iii | Date: | Thu, 01 Aug 2002 03:19:39 +0000 |
| Subject: | Re: 2 groups of random result pls help... | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-20938@lists.php.net to get a copy of this message | ||
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...
rainydays_sunshine@hotmail.com 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
ldivinag@csuhayward.edu