รบกวนช่วยดูโคีดการ query ข้อมูลแล้ว ส่งออกไปเป็น text ไฟล์หน่อยครับ ตอนนี้มันช้ามากจนแฮ้งค์เลยครับ ข้อมูลแค่ หมื่นกว่าเรคคอร์ดเอง

<?php
$objConnect = mysql_connect("localhost","root","1234") or die("Error Connect to Database");
$objDB = mysql_select_db("cu_db");

$query = "SELECT
tbl_project_info.project,
tbl_project_info.subject_no,
tbl_testtube_info.specimen_no,
tbl_testtube_info.test_type,
tbl_testtube_info.Freezer,
tbl_testtube_info.Rack,
tbl_testtube_info.Box,
tbl_testtube_info.Slot,
tbl_testtube_info.tube_volume,
tbl_testtube_info.tube_id,
tbl_testtube_info.`status`,
tbl_testtube_info.datecheck,
tbl_testtube_info.sendto,
tbl_testtube_info.dateout,
tbl_testtube_info.cnt_flag,
tbl_testtube_info.comment,
Labtest.specimen_type

FROM

tbl_project_info
Inner Join tbl_testtube_info ON tbl_project_info.speciment_no = tbl_testtube_info.specimen_no
Inner Join (SELECT DISTINCT tbl_labtest.LaboratoryTesting, tbl_labtest.specimen_type FROM tbl_labtest WHERE tbl_labtest.Project =  'KFCS') AS Labtest ON tbl_testtube_info.test_type = Labtest.LaboratoryTesting  " ; 

$result = mysql_query($query);



$output = "project, subject_no,specimen_no,test_type,Freezer,Rack,Box,Slot,tube_volume,tube_id,status,datecheck,sendto,dateout,cnt_flag,comment,specimen_type  \r\n";

while($row= mysql_fetch_array($result)){
  $output = $output . $row['project'] . ", " . $row['subject_no'] ."," . $row['specimen_no'] .", " . $row['test_type'] .", " . $row['Freezer'] .", " . $row['Rack'] .", " . $row['Box'] .", " . $row['Slot'] .", " . $row['tube_volume'] .", " . $row['tube_id'] .", " . $row['status'] .", " . $row['datecheck'] .", " . $row['sendto'] .", " . $row['dateout'] .", " . $row['cnt_flag'] ."," . $row['comment'] .", " . $row['specimen_type'] ."\r\n";
}
$newfile="newfile.txt"; 
$file = fopen ($newfile, "w"); 
fwrite($file, $output); 
fclose ($file); 
?>
<a href="newfile.txt">Left click to view the list - Right click to save the list</a>