Random SELECT

[essexboyracer]

How would I do a random select using RAND() in the mysql statement?

$result=mysql_query("SELECT title, cat FROM forsale WHERE new=1 RAND() LIMIT 10");

I have tried it but to no avail.

OR

do i go about it the other way round using php, something like

$ints = range (1, 100);

srand (time());
shuffle ($ints);
while (list ( , $num) = each ($ints)) {

echo ("$num<BR>\n");
}

I tried this also but im unsure of where to put the $result?

Any help greatly appreciated . .
oli

[essexboyracer]

$result=mysql_query("SELECT title, (ID*0+RAND()) as rand, cat FROM forsale WHERE new=1 ORDER BY rand LIMIT 7");

simple, eh.

Love
oli