Example #1
0
function PF_calculateclass($classid)
{
    $sSQLCmd = "update class set";
    $sSQLCmd .= " graduationcount=(select count(*) from classmember where isgraduation=1 and classmember.classid=class.classid ), ";
    $sSQLCmd .= " certificatecount=(select count(*) from classmember where naharegistrationkind is not null and classmember.classid=class.classid ) ";
    $sSQLCmd .= "where classid=" . PF_ReSqlCmd($classid, "N");
    PF_Get_rs($conn, $sSQLCmd);
}
Example #2
0
?>
</span> 筆</p>
              </div>
              <div class="BBTD">
<?php 
foreach ($XmlDoc->xpath("//參數設定檔/產品種類/KIND") as $v) {
    ?>
            
              	  
                <div class="nbn">
                  <p class="tp"><?php 
    echo $v->簡述;
    ?>
</p>
                  <p class="tpn"><?php 
    echo PF_GETField($conn, "select count(*) from aacd where product_category=" . PF_ReSqlCmd(strval($v->傳回值), "N"));
    ?>
</p>
                </div>
<?php 
}
?>
   
					              </div>

            </div>
        </div>
      </div>
    </div>
    			
</form>