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>";

    }
}

I receive " PHP Notice: Undefined offset: 2", but I don't understand what's the problem. Please help to me to fix that.

Thank you!

$data[2] does not exist, what is in fgetcsv() ?

v0d1ch
– v0d1ch

2013-01-05 21:18:58 +00:00
Commented Jan 5, 2013 at 21:18 — v0d1ch
– v0d1ch, Commented Jan 5, 2013 at 21:18
I can print $data[2]. It's a CSV file.

user25381
– user25381

2013-01-05 21:23:53 +00:00
Commented Jan 5, 2013 at 21:23 — user25381
– user25381, Commented Jan 5, 2013 at 21:23

kirilloid · Accepted Answer · 2013-01-05 21:19:58Z

1

$data just don't have 3rd column (indexed 2) on some iteration.

You can check that within a loop: if (!isset($data[2])) { ...

answered Jan 5, 2013 at 21:19

kirilloid

14.4k6 gold badges42 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

user25381 Over a year ago

$data[2] exists, I can print it, but it's not working inside the mysql query. $data is a csv file, but I had to rebuild it.

tmuguet Over a year ago

If you have the notice, it means there is at least one row where $data[2] does not exist. Maybe an empty line at the end ?

user25381 Over a year ago

Yes, there was an empty line. Thank you!

Collectives™ on Stack Overflow

MYSQL query: Undefined offset: 2

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related