$query2 = productquery()." AND pro_show=1 AND pro_id!='$pro_id' AND pro_cg_id='$pro_cg_id' ORDER BY RAND() LIMIT 0,3";
// echo $query2;
$sql2 = $DB->query($query2);
$num2 = $DB->num_rows($sql2);
$html = "";
$i=1;
while($row = $DB->fetch_assoc($sql2)){
$pro_id = $row['pro_id'];
$pro_code = changegb(stripslashes($row['pro_code']));
$pro_name = changegb(stripslashes($row['pro_name']));
$cg_name = changegb(stripslashes($row['cg_name']));
$pro_desc = changegb(stripslashes($row['pro_desc']));
$pi_filepass = ($row['pi_file']!='')?"upload/product/$row[pi_file]":"images/nopic.jpg";
$html .= productshow2($pro_id,$pi_filepass,$pro_code,$pro_name,$cg_name);
$i++;
}
echo $html;
?>