do i need 2 queries just for an ORDER BY change?

[RCB]

 

 

hey guys i was just wondering if  i have to make 2 separate queries to get basically the same info just display in a different order... can i do it with 1 query?

 

the first 1 would be

 

 

ORDER BY added DESC

 

second would be

 

ORDER BY rand()

 

thx

 

 

 

 

 

 

[revraz]

You can use one if you use a variable as your ORDER BY

[sasa]

maybe

<?php
$result = mysql_query("SELECT ... ORDER BY added DDESC");
$order = range(0, mysql_num_rows($result));
foreach ($order as $i){
echo mysql_result($result, $i, 'field name');
// etc.
}
shuffle($order);
foreach ($order as $i){
echo mysql_result($result, $i, 'field name');
// etc.
}
?>