MYSQL query: Undefined offset: 2

Question

$tsvhandle = fopen($tsvfile, 'r'); 
while (($data = fgetcsv($tsvhandle, 1000, ";")) !== FALSE) {
    $result = mysql_query("SELECT `post_id` FROM `charvest_postmeta` WHERE `meta_key` = '_sku' AND `meta_value` = '".$data[2]."'") or die($result."<br/><br/>".mysql_error());
    while($row = mysql_fetch_array($result)){
        echo $row['post_id']. "</br>";
    }
}

我收到" PHP通知:未定义的偏移量:2"，但我不明白是什么问题。请帮我修一下。

谢谢!

Answer 1

$data在某些迭代中没有第三列(索引为2)

可以在循环中检查:if (!isset($data[2])) { ...