Back again with another problem query...
I have a table called urls
in this table i have 4 fields:
url_id (primary key)
url_url - (unique)
the url_module field will be one of 5 values:
what im trying to do is select a random row for each url_module type so that the result will consist of 1 random forum url, 1 random products url, 1 random links url, 1 random blogs url and 1 random gallery url..
does that make sense? and is it possible to achieve this in one query using group by or order by or distinct or ...
I would appreciate any help or pointing in the right direction