Message-
From: Dan Muey [mailto:[EMAIL PROTECTED]
Sent: Monday, August 11, 2003 9:02 AM
To: James Johnson; [EMAIL PROTECTED]
Subject: RE: Form values are truncated
All,
Howdy,
I'm building a member signup form. Fields that contain more
than one word are being truncated when being
All,
Howdy,
I'm building a member signup form. Fields that contain more
than one word are being truncated when being inserted into
the MySQL table.
I'm using this code that I got from one of my PHP books.
$as_addr1 = addslashes($_POST['addr1']);$tr_addr1 = trim($as_addr1);
I
]
Subject: RE: Form values are truncated
Functions can be looked up at www.php.net, trim is at
http://us2.php.net/manual/en/function.trim.php
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
:
Subject: RE: Form values are truncated
08/11/2003 12:00
Hi now,
James Johnson [EMAIL PROTECTED], Montag, 11. August 2003 17:49:
All,
I'm building a member signup form. Fields that contain more than one word
are being truncated when being inserted into the MySQL table.
I'm using this code that I got from one of my PHP books.
$as_addr1 =
Have You solved?
Do You use GET or POST method?
What happens without trim?
Do You test errors after the insert?
if( mysql_errno() != 0)
echo mysql_errno() . : . mysql_error() . BR;
What happens if Yoy type (cut paste) the query in a terminal with mysql?
I
On 11 Aug 2003 at 8:49, James Johnson wrote:
I'm building a member signup form. Fields that contain more than one
word are being truncated when being inserted into the MySQL table.
It's very unlikely this has anything to do with MySQL or PHP. It
sounds like you're missing quotes around the