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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
