mysql field getting cut off
| From: | Larry Brown | Date: | Fri, 30 May 2003 01:30:45 +0000 |
| Subject: | mysql field getting cut off | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-149510@lists.php.net to get a copy of this message | ||
If anyone can help I seem to be stuck on a problem getting a mysql field
inserted correctly. For instance the first page would have a field such
as...
<input type="text" name="field" size="12">
info that is placed into the field is "St. Petersburg, FL" (without the
quotes)
the php code for the statement...
$query = "insert into table values( $variable, '$field', $variable2 )";
This is where there are 3 fields in the "table" and the second is the one I
want populated with "St. Petersburg, FL". It ends up with "St." (I'm not
sure if the period makes it). I have verified that the entire statement
arrives at the php script in the variable $field and I have used the mysql
client to give the same command with "St. Petersburg, FL" as the value and
it accepts it without a problem.
Larry S. Brown
Dimension Networks, Inc.
(727) 723-8388