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
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() . "";
What happens if Yoy type (cut & paste) the query in a terminal with mysql?
]
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]
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_
; cc:
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 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)
defined functions out there?
Thanks,
James
-Original 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
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 = addslashes($_POST['addr1']);$tr_addr1 = trim($as_addr1);
So, if I post "1122 Boogie
