<?

 include("config.php");

 $i_input = "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n";
 $i_input .= "<root>\n";
 for($i=0; $i < 5; $i++) {
  $j=0;
  if($i == 0) { $where_i = "g_best = 'y' order by no desc limit 0,4"; }
  if($i == 1) { $where_i = "g_new = 'y' order by no desc limit 4, 4"; }
  if($i == 2) { $where_i = "g_hot = 'y' order by no desc limit 8, 4"; }
  if($i == 3) { $where_i = "g_best = 'y' order by no desc limit 12, 4"; }
  if($i == 4) { $where_i = "g_new = 'y' order by no desc limit 16, 4"; }

  $i_input .= "<rows category=\"$i\">\n";
  $query="select * from goods where $where_i  ";
  $result=mysql_query($query);
  while ($row= mysql_fetch_array($result)) {

   $min_price_tmp=split("[|]",$row[goods_price]);
   $min_price = split("[-]",$min_price_tmp[0]);
   $mini_price = str_replace(",", "", $min_price[1]);
   $mini_mileage = number_format($mini_price - ($mini_price*(0.1)));
   $mini_member = number_format($mini_price - ($mini_price*(0.05)));

   $goods_name =
   $goods_name = iconv("euckr","utf-8",$row[goods_name]);

   $zoom_link = "javascript:MM_openBrWindow('/zoomImg.php?imgfile_name=prog/goods/imgs/$row[goods_imgs]', 'bigPhoto$row[no]', 'width=200, height=200, resizeable=yes');";

   $i_input .= "<row>\n";
   $i_input .= "<order>$j</order>\n";
   $i_input .= "<imgSrc><![CDATA[http://ifull.co.kr/prog/goods/imgs/".$row[goods_imgs]."]]></imgSrc>\n";
   $i_input .= "<itemTitle><![CDATA[".$goods_name."]]></itemTitle>\n";
   $i_input .= "<isSpecial>1</isSpecial>\n";
   $i_input .= "<zoomSrc><![CDATA[".$zoom_link."]]></zoomSrc>\n";
   $i_input .= "<price>".$min_price[1]."</price>\n";
   $i_input .= "<price4Member>".$mini_member."</price4Member>\n";
   $i_input .= "<saveAmount>".$mini_mileage."</saveAmount>\n";
   $i_input .= "<link><![CDATA[/prog/shopping/goods_detail.php?goods_code=".$row[goods_code]."&sub_folder_code=".$sub_folder_code."&root_folder_code=shop&mode=$mode&keyword=$keyword&cpage=mainBest5&head_tf=$head_tf#".$row[goods_code]."]]></link>\n";
   $i_input .= "</row>\n";
   $j++;
  }
  $j =0;
  $i_input .= "</rows>\n";
 }
 $i_input .= "</root>\n";

 $fp = fopen("bestofbest.xml","w");  // 바로 생성처리 하기
 fputs($fp, $i_input);
 fclose($fp);

?>

  생성된 처리결과 입니다.

  그냥 코딩으로 전부 제작했습니다;;

  좀더 열심히 하겠습니다.