使用PHP插入数据库 - 只插入一行

Question

I am trying to insert multiple rows into a Table from a Textfile. The code below only seems to insert the first row from the Textfile. How can I change it so that it will loop through and insert the rest of the rows?

$rwy = "./rwy.txt";

if (file_exists($rwy)) {
sql('TRUNCATE rwy_current');

$array = file($rwy);

foreach ($array as $line) {
    $bits = explode("
", $line);
    foreach ($bits as $row) {
        $col = explode("\t", $row);
        sql("INSERT INTO rwy_current (arpt_ident, high_ident, low_ident, high_hdg, low_hdg, length, surface, pcn, he_elev, he_slope, he_tdze, le_elev, le_slope,
              le_tdze, he_true_hdg, le_true_hdg, heland_dis, he_takeoff, leland_dis, le_takeoff, cycle_date)
             VALUES ('$col[0]', '$col[1]', '$col[2]', '$col[3]', '$col[4]', '$col[5]', '$col[7]', '$col[8]', '$col[13]', '$col[14]', '$col[15]', '$col[30]',
              '$col[31]', '$col[32]', '$col[43]', '$col[44]', '$col[46]', '$col[47]', '$col[48]', '$col[49]', '$col[50]')
           ");
        }
    }
}

Answer 1

alter table rwy_current add primary key (arpt_ident, high_ident, low_ident);

Solved it

Problem was in the database; I only had one Primary Key set.