Re: Help with SQL Query String

well...i would have told him to go pound sand...the php manual is great and so is the MySQL manual. People are just lazy.

[/snip] Ya'll bitch when I make them RTFM, ya'll bitch when I do code....what's a guy to do? j/k Actually http://dev.mysql.com/doc/mysql/en/string-functions.html shows that MySQL also has a trim function which could be applied thusly; $sql = "INSERT INTO tblname (USERID,FULLNAME,SSN,STARTDATE) "; $sql .= "VALUES ( "; $sql .= "TRIM('" . $row['USERID'] . "'), "; $sql .= "TRIM('" . $row['FULLNAME'] . "'), "; $sql .= "TRIM('" . $row['SSNO'] . "'), "; $sql .= "TRIM('" . $row['STARTDATE'] . "') "; $sql .= ") "; -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php