こちらがそのソースです。
//一覧情報取得 $result = $mydb->get_results(" SELECT post_title, id, guid, post_excerpt, m1.meta_value AS 'short', m2.meta_value AS 'all', m3.meta_value AS 'des', m4.meta_value AS 'com' FROM wpd27b99posts INNER JOIN wpd27b99postmeta AS m1 ON m1.post_id = wpd27b99posts.ID /* テーブルを結合-カスタムフィールド */ INNER JOIN wpd27b99postmeta AS m2 ON m2.post_id = wpd27b99posts.ID /* テーブルを結合-カスタムフィールド */ INNER JOIN wpd27b99postmeta AS m3 ON m3.post_id = wpd27b99posts.ID /* テーブルを結合-カスタムフィールド */ INNER JOIN wpd27b99postmeta AS m4 ON m4.post_id = wpd27b99posts.ID /* テーブルを結合-カスタムフィールド */ WHERE post_type = 'voice' AND post_status = 'publish' /* かつ公開済の記事 */ AND m1.meta_key = 'letter_short' AND m2.meta_key = 'letter_all' AND m3.meta_key = 'description' AND m4.meta_key = 'comment' ORDER BY post_date DESC /* 新しい順に並び替え */"); $thumb = $mydb->get_results(" SELECT guid FROM wpd27b99posts, wpd27b99postmeta /* テーブルを指定 */ WHERE wpd27b99posts.post_type = 'attachment' AND wpd27b99posts.ID = wpd27b99postmeta.post_id /* テーブル同士の結びつけ */ AND wpd27b99postmeta.meta_key = '_wp_attached_file' AND post_parent != 0 "); foreach ($thumb as $img) : echo "<p><img src=".$img->guid." alt='ここに画像' /></p>"; endforeach; //表示 foreach ($result as $obj) : echo "<div id='post-".$obj->id."' class='post type-post status-publish format-standard hentry category-sonota'>"; echo "<a class='relatedimg' style='text-decoration:none;' href=\"". get_permalink($value+0) . "\" title=\"". $zg_title_out->post_title . "\"><img src=".$obj->guid." alt='ここに画像' />" . $zg_title_out->post_title . "</a>"; echo "<h3>"; echo "<a href=".$obj->guid.">"; echo "$obj->post_title"; echo "</a>"; echo "</h3>"; echo "<p>$obj->post_excerpt</p>"; echo "<p>手紙の本文(短め): {$letter_short}$obj->short</p>"; echo "<p>手紙の本文(全文) : {$letter_all}$obj->all</p>"; echo "<p>実績概要: {$description}$obj->des</p>"; echo "<p>コメント: {$comment}$obj->com</p>"; echo "</div>"; endforeach;
回答1件
あなたの回答
tips
プレビュー