Posted by Rik on 03/06/07 09:11

Geoff Berrow <blthecat@ckdog.co.uk> wrote:

> Message-ID: <op.torcq8kbqnv3q9@misant> from Rik contained the following:
>
>> Raj, look up what crossposting and multiposting is, and why it's frowned
>> upon
>
> To be fair, /I/ would have been interested in a purely SQL solution even
> though I'm only reading php groups. (my solution would have been to
> query with a LIMIT 0,n and do the rest with PHP).

Well, just to indulge you: the secret is ORDER BY RAND(). And you don't
need the '0,' in the LIMIT statement.

> However it /is/ preferable to post in one relevant group first and then
> widen your search in other groups if you do not get a solution.

Indeed.
--
Rik Wasmus
Posted on Usenet, not any forum you might see this in.
Ask Smart Questions: http://tinyurl.com/anel

[Back to original message]