$result = mysql_query("SELECT n.sbjnum, n.scan_no, d.name, d.tel_c, d.srvyr
FROM no_scans AS n
JOIN details AS d ON n.sbjnum = d.sbjnum ");
while ($row = mysql_fetch_array($result)) {
echo $string1 = implode(" , ",$row) . "<br />";
}
mysql_fetch_array()
以关联形式和数字索引形式返回列数据的数组。您需要使用mysql_fetch_assoc()
。
您可能想尝试使用fputcsv()