<?
$rs_new=mysql_query("select id from products where new='1' and show_product='1'");
$num_new=mysql_num_rows($rs_new);
$i=0;
while($rows_new=mysql_fetch_assoc($rs_new)){
$new[$i]=$rows_new['id'];
$i++;
}
shuffle($new);
for($i=0;$i<$num_new;$i++){
$rs_new=mysql_query("select * from products where id='$new[$i]'");
$show=mysql_fetch_assoc($rs_new);
//while($show=mysql_fetch_assoc($new)){
?>