使用内爆从联接表上的mysql_query生成csv文件,输出会给出重复的字段


Using implode to generate csv file from mysql_query on joined tables, output gives fields duplicated?

$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()