'; $information .= "\n"; //Standard 3-1 $information .= "\n"; //project $information .= "\n"; $dsn_name = "staff"; $username =""; $password =""; $connect= odbc_connect($dsn_name, $username, $password) or die("µÔ´µèÍ DSN äÁèä´é"); //selece_database_project $sql = "SELECT * FROM TFileCommittee, TEmployee WHERE TFileCommittee.TEmp_id=TEmployee.Id"; //$sql = "SELECT * FROM TProject"; $execute = odbc_exec($connect, $sql) or die ("àÍç¡«Ô¤ÔÇÊì¤ÓÊÑè§äÁèä´é"); $i=1; $num1=0; $TEmployee_id_check=""; while($row = odbc_fetch_array($execute)) { $TEmployee_id=$row['Id']; $TEmployee_fname=$row["fname"]; $TEmployee_lname=$row["lname"]; $TFileCommittee_order_no=$row["order_no"]; $TFileCommittee_ttile=$row["TTitle"]; if($TEmployee_id!=$TEmployee_id_check) { $num1++; } $TEmployee_id_check=$TEmployee_id; $information .= "\n"; $information .= "\n"; $information .= "$TEmployee_id"; $information .= "\n"; $information .= "\n"; $information .= "$TEmployee_fname"; $information .= "\n"; $information .= "\n"; $information .= "$TEmployee_lname"; $information .= "\n"; $information .= "\n"; $information .= "$TFileCommittee_order_no"; $information .= "\n"; $information .= "\n"; $information .= "$TFileCommittee_ttile"; $information .= "\n"; $information .= "\n"; } //end_selece_database_project $information .= "\n"; //project $information .= "\n"; $information .= "$num1"; $information .= "\n"; $information .= "\n"; //end _ Standard 3-1 $information .= "\n"; echo "$information"; ?>