"; echo "

Select:

"; $sql = "select sec.id, sec.section, count(ar.id) cnt from section sec, article_section asec, article ar where sec.id = asec.section_id and asec.article_id = ar.id and ar.seq_id > 0 and sec.category_id = 1 group by sec.id order by sec.section"; $result = mysql_query($sql); while ($data = @mysql_fetch_array($result)) { $sc = $data["section"]; $cnt= $data["cnt"]; if ($cnt > 0) { echo "$sc"; } } echo "

"; echo "

Select:

"; $sql = "select sec.id, sec.section, count(ar.id) cnt from section sec, article_section asec, article ar where sec.id = asec.section_id and asec.article_id = ar.id and ar.seq_id > 0 and sec.category_id = 2 group by sec.id order by sec.section"; $result = mysql_query($sql); while ($data = @mysql_fetch_array($result)) { $sc = $data["section"]; $cnt= $data["cnt"]; if ($cnt > 0) { echo "$sc"; } } echo "