$lines = explode("\n",$bank_data); $out = array(); foreach($lines as $line) { $parts = explode("/",$line); mysql_query("INSERT INTO item_table (item_name, item_quantity, item_level, item_type, item_id) VALUES ($parts[0],$parts[1],$parts[2],$parts[3],$parts[4],)"); // $out[] = $parts; }