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; ?>