Php while loop is returning each second value

Question

I have such code to get via odbc some data...

     $data = odbc_exec($this->odbc_id, $odbc_query);
     odbc_longreadlen($data, 10485760); //10MB = 10485760
     while(odbc_fetch_row($data)) 
     { 
     $row = odbc_fetch_array($data);
     if($row['graphID'] != "") {
     $file_name_jp2 = "TI/" . $table_name . "/" . $row['graphID'] . ".jp2";
     $file = fopen ($file_name_jp2, "w");
     fputs($file, $row['graph']);
     fclose($file);
     set_time_limit(3600);
 }

 unset($row);
 }

but for some reasons it is fetching each each second db entrie... But why? What i write wrong?

What to change to fetch all data?

juco · Accepted Answer · 2013-02-23 18:15:08Z

2

You're using both odbc_fetch_array and odbc_fetch_row, you should be using one of the other. Something similar to:

while($row = odbc_fetch_array($data)) {
  // As you were..
}

And remove your line:

$row = odbc_fetch_array($data);

answered Feb 23, 2013 at 18:15

juco

6,3423 gold badges27 silver badges42 bronze badges

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

Collectives™ on Stack Overflow

Php while loop is returning each second value

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related