Re: Re[2]: [PHP-DB] MySQL: Random select with specific count of a column

2004-07-06 Thread Torsten Roehr
"Pablo M. Rivas" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hello Torsten, > > > TR> thanks for your help. Unfortunately it's always returning the same row for > TR> each category (maybe because of the group by) and only one row for each > TR> category. I need to select 2 random

Re[2]: [PHP-DB] MySQL: Random select with specific count of a column

2004-07-05 Thread Pablo M. Rivas
Hello Torsten, TR> thanks for your help. Unfortunately it's always returning the same row for TR> each category (maybe because of the group by) and only one row for each TR> category. I need to select 2 random rows for each category. Any more ideas? I'ts returning 2 rows each RECORD, but the fie