為了方便查考,本章把 FOF.bnk 資料庫 1254 筆時間序列資料之檢索代號依分類表格一一列舉出來。總共含有 22 個表,其名稱與頁次如下:
// $sql_str = "SELECT distinct book FROM aremos_key where data_bank='$databank' order by locate(left(book,1),'一二三四五六');"; $sql_str = "SELECT distinct book FROM aremos_key where data_bank='$databank' order by book;"; $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)) { ?>
} } } ?>