Date: 07/21/06 (PHP Community)    Keywords: mysql, sql

i have this function the reads a csv file (it's actually a pipe-separated file...), exported from access and dumped into mysql. after some formatting and setting things up, i start a while... loop, reading each line of the file and updating or inserting into the table as necessary. my problem is that after the while loop, the script seems to just die. everything is updated/inserted correctly, but it just stops after the loop. the "report" code never happens. the stuff that executes outside of the function after i call it never happens. can anyone see anything wrong with this? i can post the entire function if you'd like.


while (!feof($csv_file)) { $line = fgets($csv_file); $line = str_replace('"','',$line); $line = explode('|',$line); //check for existing row $sql = "SELECT `id` FROM `cards` WHERE `record_number` = {$line[0]}"; $res = mysql_query($sql); //row exists, update (might be faster to check for changes first...) if(mysql_num_rows($res)) { $updated_rows++; foreach($line as $key => $val) { $update_data[$csv_fields[$key]] = addslashes($val); } foreach($update_data as $key => $val) { $sql = "UPDATE `cards` SET `$key` = '$val' WHERE `record_number` = {$line[0]}"; mysql_query($sql) or die("tragic error: failed to update record ".$line[0]." <br/> $sql"); } } //row doesn't exist, add else { $inserted_rows++; foreach($line as $key => $val) { $insert_data[$csv_fields[$key]] = addslashes($val); } $sql = "INSERT INTO `cards` ("; foreach($insert_data as $key => $val) { $sql .= "`$key`,"; } $sql = rtrim($sql,','); $sql .= ") VALUES ("; foreach($insert_data as $key => $val) { $sql .= "'$val',"; } $sql = rtrim($sql,','); $sql .= ")"; mysql_query($sql) or die("tragic error: failed to insert record ".$line[0]." <br/> $sql"); } } //report! echo "<strong>RESULTS</strong><br/><br/>"; if (count($inserted_columns) > 0) { echo "added the following fields:<br/>"; foreach($inserted_columns as $col) { echo "    ".$col."<br/>"; } } echo "<br/>updated $updated_rows existing rows"; echo "<br/>inserted $inserted_rows new rows"; //clean up fclose($csv_file); echo "closed file";

Source: http://community.livejournal.com/php/473329.html