formatting form input/sql insert

From: Date: Tue, 16 Apr 2002 15:03:58 +0000
Subject: formatting form input/sql insert
Groups: php.general 
Request: Send a blank email to php-general+get-93206@lists.php.net to get a copy of this message
I'm collecting data with from textarea inputs. The user may enter a linebreak with the return key, or a tab, etc. I then write this data to a mySQL table, formatting the data with addslashes(). I then output the data to a text file using a "select into file" statement. When I import the file into excel, or view it with an editor, the user entered tabs & linebreaks are being interpreted as field separators and record separators. How do I format the input to solve this problem? Thanks! -Bob

« previous php.general (#93206) next »