"); connect_to_db() ; $query ="select topic_name from topics where topic_no='$topicno'"; $result = mysql_query($query); $row = mysql_fetch_array($result); //$temp="

".$row["topic_name"]." 網路問卷調查

\n $temp="

".$row["topic_name"]."

\n \n"; fputs($fp_new, $temp); $query ="select ques_no,ques_content,ques_ans from questions where ques_topic_no='$topicno' order by ques_no"; $result = mysql_query($query); $num_results = mysql_num_rows($result); // echo "\n\n "; $temp="

\n"; for ($i=0; $i <$num_results; $i++){ $row = mysql_fetch_array($result); $temp=$temp."\n \n \n \n"; $query ="select ques_label_seq,ques_label from labels where ques_topic_no='$topicno' and ques_no='".$row["ques_no"]."' order by ques_label_seq"; $result1 = mysql_query($query); $num = mysql_num_rows($result1); $temp=$temp."\n \n \n"; } $temp=$temp."

".$row["ques_no"]."		".$row["ques_content"]; if ( $row["ques_ans"]=='2') // $temp=$temp."(可複選)"; $temp=$temp."
		"; for ($j=0; $j <$num; $j++){ $row1 = mysql_fetch_array($result1); if ($row1["ques_label_seq"]==999) $temp=$temp."".$row1["ques_label"].""; else{ if ( $row["ques_ans"]=='1') $temp=$temp.""; else $temp=$temp.""; // echo $row1["ques_label_seq"]; $temp=$temp.$row1["ques_label"]; $temp=$temp." "; } } if ( $row["ques_ans"]=='3') $temp=$temp.""; $temp=$temp."

"; fputs($fp_new, $temp); fclose($fp); fclose($fp_new); echo "問卷調查網頁所在網址為： http://".$_SERVER['HTTP_HOST']."/".$HTML_FILE."" ; ?>