Hi,

Mmm.. not easily :/

Would be possible to do it with DISTINCT(LinkID), *but* it would double the work - cos it would need to do something like:

Get list of Distinct ID's (random)
Get the record for each of the ID's grabbed

..instead of just:

get the list of ID's

Cheers

Andy (mod)
andy@ultranerds.co.uk

---

Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!