Hi Dan, all, I don't know PERL, just coming back to speed on PHP after 3+ years with ColdFusion.
Trim() is a function listed in my PHP Functions book, not something I wrote. It's supposed to: "removes all whitespace characters from both the left and right ends of a string..." A space (ASCII 32) is considered a char to remove, but since it's in the middle of the string, I don't understand why it's being removed. "or you could fix or replace the trim function with one that does not remove that data." Is there a library of PHP user 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 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 think trim is trimming off the stuff after the first whitespace? What is the trim function supposed to do? Mysql isn't doing it your PHP is. Use Perl and I bet it starts working :) ok, or you could fix or replace the trim function with one that does not remove that data. HTH DMuey > > So, if I post "1122 Boogie St." it gets inserted as "1122". > If I remove the "addslashes" portion, only using trim, I get > the same result. > > Here's the query: > $query = "INSERT INTO subscribers > (email,password,fName,lName,addr1) > VALUES > ('$tr_email','$tr_pass','$tr_fName','$tr_lName','$tr_addr1'"; > > echo $query; > > Here's the echo: > INSERT INTO subscribers (email,password,fName,lName,addr1) > VALUES('[EMAIL PROTECTED]','11111111','Jim','Johnson','78797 State') > > I have other fields in the table that are doing the same > thing. All fields are varchars of varying length. Field > "addr1" is varchar(50). > > Suggestions? > Thanks, > James -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
