Multiple word strings getting truncated - help please.
| From: | James Johnson | Date: | Sat, 30 Aug 2003 21:52:30 +0000 |
| Subject: | Multiple word strings getting truncated - help please. | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-161274@lists.php.net to get a copy of this message | ||
Hi,
I have a form for a member to signup for an account. The form has standard
fields for addresses, city state, etc. When I insert the data into the
table, if the string has more than one word, it gets truncated to the first
word.
Does this sound like a PHP or a MySQL problem.
Here's the code: (partial as the query is quite long)
$tr_addr1 = $_POST['addr1']
$query = "INSERT INTO subscribers (addr1) VALUES('$tr_addr1')";
The MySQl table is as such:
addr1 = varchar(50)
Thanks,
James