formatting form input/sql insert
| From: | ROBERT MCPEAK | 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