I have a query:
Code: Select all
$result = mysql_query("Select * from venue_dir where moderated = 'Y' order by ven_enhanced DESC, ven_name ASC limit $offset, $limit ");What I would like to do is take the results that are enhanced and randomise their order.
Can this be done and how would I do it?
Thanks in advance