[grant.hayman]

hi MoT3rror,

I can't see a way of doing this in 1 query as the 4 selects are getting diffrent type of ads, size and position plus each select will be getting random results.

from what I can see it would definetly need 4 selects but was wondering if union them all would be better for vb so that all the results will come back in 1 result set.

it would be easier to do 4 diffrent selects from a coding point of view but I am thinking it might be a bit heavy on vb to do 4 extra selects.

simple example:

Select bannercode from table where "where clause"
ORDER BY RAND() LIMIT 1;
UNION
Select bannercode from table where "another where clause"
ORDER BY RAND() LIMIT 2;
UNION
Select bannercode from table where "another where clause"
ORDER BY RAND() LIMIT 1;
UNION
Select bannercode from table where "another where clause"
ORDER BY RAND() LIMIT 1;

Grant

----------------------------------------

After playin with this it seems it is impossible to union and rand() all the selects so it looks like im going to have to do 4 selects anyway