On 3/31/05 12:45 PM, "Joseph Connolly" <jozef1@xxxxxxxxx> wrote: > 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. Ave, "Pound sand" .. Interesting. And yes, both the manuals are great, and people are extremely lazy and purposely idiotic, nonsensical and absurdly inconclusive of the inadequacies of their lifeless brains. Have an awesome day. PS: Jay.. The code works great... Thanks a ton again! Rahul S. Johari Coordinator, Internet & Administration Informed Marketing Services Inc. 251 River Street Troy, NY 12180 Tel: (518) 266-0909 x154 Fax: (518) 266-0909 Email: rahul@xxxxxxxxxxxxxxxxxxxx http://www.informed-sources.com >>> [/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
