include "./dbconn.php";
$sql = "select post_id,meta_key,meta_value from wp_postmeta where meta_key like 'wpcf-hangeul%' group by post_id asc ";
$stmt = $pdo->prepare($sql);
$stmt->execute();
$i = 1;
while($row = $stmt->fetch()){
//echo $i." / ".$row[post_id]." / ".$row[meta_key]." / ".$row[meta_value]."
";
$sql = "select post_id,meta_key,meta_value from wp_postmeta where post_id='{$row[post_id]}' order by ( case ";
$sql.= " when meta_key='wpcf-hangeul' then 1 ";
$sql.= " when meta_key='wpcf-hanmun' then 2 ";
$sql.= " when meta_key='wpcf-academic' then 3 ";
$sql.= " when meta_key='wpcf-address' then 4 ";
$sql.= " when meta_key='wpcf-addsite' then 5 ";
$sql.= " when meta_key='wpcf-birth' then 6 ";
$sql.= " when meta_key='wpcf-caddress' then 7 ";
$sql.= " when meta_key='wpcf-company1' then 8 ";
$sql.= " when meta_key='wpcf-company2' then 9 ";
$sql.= " when meta_key='wpcf-company3' then 10 ";
$sql.= " when meta_key='wpcf-cphone' then 11 ";
$sql.= " when meta_key='wpcf-death' then 12 ";
$sql.= " when meta_key='wpcf-display' then 13 ";
$sql.= " when meta_key='wpcf-email' then 14 ";
$sql.= " when meta_key='wpcf-homepage' then 15 ";
$sql.= " when meta_key='wpcf-image1' then 16 ";
$sql.= " when meta_key='wpcf-image2' then 17 ";
$sql.= " when meta_key='wpcf-image3' then 18 ";
$sql.= " when meta_key='wpcf-image4' then 19 ";
$sql.= " when meta_key='wpcf-image5' then 20 ";
$sql.= " when meta_key='wpcf-lastdate' then 21 ";
$sql.= " when meta_key='wpcf-major_txt' then 22 ";
$sql.= " when meta_key='wpcf-major_txt2' then 23 ";
$sql.= " when meta_key='wpcf-major_txt3' then 24 ";
$sql.= " when meta_key='wpcf-major_txt' then 25 ";
$sql.= " when meta_key='wpcf-treatise' then 26 ";
$sql.= " when meta_key='wpcf-prize' then 27 ";
$sql.= " when meta_key='wpcf-public_ability then 28 ";
$sql.= " when meta_key='wpcf-now_active then 29 ";
$sql.= " when meta_key='wpcf-penname then 30 ";
$sql.= "end ) asc";
$stmt2 = $pdo->prepare($sql);
$stmt2->execute();
//echo $i;
while($row2 = $stmt2->fetch()){
echo $i." / ".$row2[post_id]." / ".$row2[meta_key]." / ".$row2[meta_value]."
";
}
$row2 = null;
$i++;
}
$pdo = $stmt = $row = null;
?>