until now,the best i could get was getting 6 random rows...still working on ensuring to retrive just 2 rows for category...meanwhile,you can solve the problem easily with a php loop trough the following query:
select field_id , language , category
from yourtable
where language = 'de'
group by category , field_id
order by category , rand()
limit 6;
PS1: i'm considering you're using just one table and my table structure is as follows: yourtable (field_id , language, category).
in case you're using more than 1 table, just add the required joins...
hope this helps.
Rui Cunha
Torsten Roehr writes:
"Pablo M. Rivas" <pmrivas01@xxxxxxxxxxxx> wrote in message news:12572007801.20040629110044@xxxxxxxxxxxxxxxHello Torsten,
This is one, but I think you can find another one:
Supose your table is called tablename
select * from tablename as a left join tablename as b on a.category = b.category and a.name<>b.name and a.language=b.language where a.language='de' and b.name is not null group by a.category
Hi Pablo,
thanks for your help. Unfortunately it's always returning the same row for
each category (maybe because of the group by) and only one row for each
category. I need to select 2 random rows for each category. Any more ideas?
Thanks, Torsten
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
