} else {
echo $ranking_type;
}
}
}
if ($level == "o") {
echo "Level: Overall";
} else {
echo " <strong>Level: </strong>" . $level;
}
if ($pool == "0") {
echo " <strong>Pool:</strong> 1<br/>";
} else {
echo " <strong>Pool:</strong> 2<br/>";
}
displayRanking($ranking_type, $level, $pool);
function displayRanking($event, $level, $pool)
{
mysql_query("TRUNCATE ranking");
$count = 0;
$result = mysql_query("SELECT * FROM school");
$schools = array();
while ($row = mysql_fetch_object($result)) {
$schools[] = $row;
}
$numOfSchools = mysql_num_rows($result);
while ($count < $numOfSchools) {
$count++;
if ($event == "o" && $level == "o") {
$result = mysql_query("SELECT*FROM score JOIN school ON score.school_id=school.id WHERE score.school_id='{$count}' AND school.league='{$pool}'");
} else {
<li data-pref="ty" class="ty">q</li>
<!-- 富山 -->
<li data-pref="wk" class="wk">r</li>
<!-- 和歌山 -->
<li data-pref="yg" class="yg">s</li>
<!-- 山口 -->
<li data-pref="ym" class="ym">t</li>
<!-- 山形 -->
<li data-pref="yn" class="yn">u</li>
<!-- 山梨 -->
</ul>
</div>
</section>
*/
//ランキング表示
displayRanking();
if (!is_home()) {
/* topには出さない */
?>
<!-- new article -->
<section>
<div class="new_article">
<div class="new_article_tittle">New posts
</div>
<!-- loop start -->
<?php
$args = 'posts_per_page=5';
query_posts($args);
// The Loop
