Posted by Joseph Connolly on 03/31/05 20:45

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
>>
>>
>
>
>

• Next in forum: Re: [PHP] Help with SQL Query String
• Prev in forum: Re: [PHP] Help with SQL Query String
• Thread view: Re: [PHP] Help with SQL Query String

[Reply to this message]