RTest

terms, $wpdb->term_taxonomy
WHERE $wpdb->terms.term_id = $wpdb->term_taxonomy.term_id
AND $wpdb->term_taxonomy.taxonomy = ‘season’
ORDER BY year + 0 DESC, FIELD(season,’Winter’,’Spring’,’Summer’,’Fall’) DESC
“;
$result = $wpdb->get_results($sql, OBJECT);
foreach ($result as $season) {
$i=0;
?>

name; ?>

term_relationships
WHERE $wpdb->term_relationships.term_taxonomy_id = $season->term_taxonomy_id
“;
$shows = array(“”);
$result = $wpdb->get_results($sql, OBJECT);
echo “

“;
foreach ($result as $post) {
$sql = ”
SELECT * FROM $wpdb->term_relationships, $wpdb->term_taxonomy, $wpdb->terms
WHERE $wpdb->term_relationships.term_taxonomy_id = $wpdb->term_taxonomy.term_taxonomy_id
AND $wpdb->term_relationships.object_id = $post->object_id
AND $wpdb->term_taxonomy.term_id = $wpdb->terms.term_id
AND $wpdb->term_taxonomy.taxonomy = ‘show’
“;
$show = $wpdb->get_row($sql, OBJECT);
if (!in_array($show->slug, $shows)) {
$shows[$show->slug] = array($show->slug, $show->name);
}
}
sort($shows);
foreach ($shows as $show) {
if (!$show == “”) {
$i++;
?>

“;
}
}
}
echo “

“;
}
}
?>
terms
WHERE $wpdb->terms.slug = ‘”. $show . “‘
“;
$result = $wpdb->get_row($sql, OBJECT);
echo “

” . $result->name . “

“;
$sql = ”
SELECT *
FROM $wpdb->term_taxonomy
WHERE $wpdb->term_taxonomy.term_id = ‘”. $result->term_id. “‘
AND $wpdb->term_taxonomy.taxonomy = ‘show’
“;
$result = $wpdb->get_row($sql, OBJECT);
echo “

” . $result->description . “

“;

$args=array(
‘show’ => $show,
‘post_type’ => ‘post’,
‘posts_per_page’ => 10,
‘caller_get_posts’=> 1,
‘orderby’ => ‘grade’,
‘order’ => ASC

);
$my_query = null;
$my_query = new WP_Query($args);
if( $my_query->have_posts() ) {
?>

have_posts()) : $my_query->the_post(); ?>
ID, ‘grade’, ”, ‘, ‘, ” ));
?>

Group Grade

Leave a Comment

© 2022 Crymore.net • Built with GeneratePress - Sitemap