rand() not working

[micmac]

Hi again,
Why wont the following query execute?

$result = mysql_query("SELECT * FROM cat1 WHERE CatParent = $id  AND active='yes' ORDER BY pref, rand('CatName') LIMIT " . $start . ", 20");

I'm trying to get the CatName values to display in random.
Any ideas?

Cheers,
micmac

[Duey]

yep here goes

mysql_query("SELECT_*_FROM_cat1_WHERE_CatParent_=_'".$id."'__AND_active='yes'_ORDER_BY_pref,_rand('CatName')_LIMIT_'".$start."', 20");

that should do it

[Weedpacket]

Can't you just have "ORDER BY pref,RAND()"? If the order of the records are randomised, it wouldn't matter what field they're randomised on...

[Duey]

sure does,

www.php.net/manual/en/function.rand.php

looks down at user comments theres a thing about using in a mysql query