$line) { // split each line; echo "$line
\n"; $et = substr($line, 0, 1); $em = substr($line, 1, 2); $ed = substr($line, 3, 2); $ey = substr($line, 5, 4); $wd = substr($line, 9, 1); $a = substr($line, 10, strlen($line) - 9); $a = addslashes($a); echo "$et, $em, $ed, $ey, $wd, $a

\n"; mysql_query ("INSERT INTO $table (eventtype, eventmonth, eventday, eventyear, weekday, article) VALUES ('$et','$em','$ed','$ey','$wd','$a')") or die("Insert Error: ".mysql_error()); } mysql_close($conn); echo " Success "; ?>