Re: uploading flat text to MySQL

On Sunday 22 December 2002 14:04, James Brennan wrote: > I'm using a HTML form to submit flat text files to a MySQL database. When I > upload the text file by FTP the script that loads it's contents into the > database works as expected. When I upload using the HTML form it seems to > ignore the new line in the text file. As a result it only creates one row > in the table with some overflow in the last cell. Does anyone know how to > deal with this? When transferring text files, the ftp client usually transparently handles the "newline" issues when going from eg DOS -> Unix, and vice-versa. If you're uploading the file via an HTML form then you're getting the file unchanged. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * /* Reputation, adj.: What others are not thinking about you. */