為了方便查考,本章把 YPF.bnk 資料庫 119 筆時間序列資料之檢索代號依財政部統計處「中華民國財政統計年報」中之表格順序一一列舉出來。 $sql_str = "SELECT distinct book FROM aremos_key where data_bank='$databank' order by locate(left(book,2),'一二三四五六');"; $result_book = mysqli_query($Conn,$sql_str); if (mysqli_num_rows($result_book)) { while ($data_book = mysqli_fetch_array($result_book)) { $book[]=$data_book['book']; } } for($i=0;$i
echo $book[$i];?> if($book[$i]==""){ $sql_str = "SELECT distinct form_c FROM aremos_key where data_bank='$databank' and (freq='A' or freq='Q' or freq='M') and isnull(book) order by form_c;"; }else{ $sql_str = "SELECT distinct form_c FROM aremos_key where data_bank='$databank' and book='$book[$i]' and (freq='A' or freq='Q' or freq='M') order by form_c;"; } // echo $sql_str; $result = mysqli_query($Conn,$sql_str); if (mysqli_num_rows($result)) { while ($data = mysqli_fetch_array($result)) { ?>
"> } } } ?>