[SOLVED] 2 ordery by's?

[ohdang888]

I have a list, and i want to order by `bid` DESC and LIMIT 4, and then i want to order those 4 by random?

how do i do that?

 

SELECT `id`, `format` FROM `test` WHERE `cat`='$cat' ORDER BY `bid` DESC  LIMIT 4 rand()

 

Thanks.

[ratcateme]

once you do that query you should put all the results into a array like this

<?php
$rs = mysql_query("SELECT `id`, `format` FROM `test` WHERE `cat`='$cat' ORDER BY `bid` DESC  LIMIT 4");
$rows = array();
while($row = mysql_fetch_assoc($rs)){
    $rows[] = $row;
}
shuffle($rows);
?>

the shuffle will randomize the 4 rows.

 

Scott.

[sasa]

SELECT * FROM (SELECT `id`, `format` FROM `test` WHERE `cat`='$cat' ORDER BY `bid` DESC  LIMIT 4) ORDER BY RAND()