Ave, Thanks a lot folks. I did actually mention that doing something like $userid = trim($row['USERID']); And then using those variables in my SQL statement would work... The only reason I chose to make this post however and not do that was because I wanted to know if it can be done the other way. I do understand though that using the PHP trim() function in an SQL statemnt won't work. However the new snip about mySQL having it's own TRIM() function is also pretty cool. Thanks again all, 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 On 3/31/05 10:30 AM, "Jay Blanchard" <jay.blanchard@xxxxxxxxxxxxxxxxxxxxx> wrote: > [snip] > You should not just give him the code but rather tell him why. > > 1. trim() is a php function. MySQL does not know what to do with it. You > > need to place it 'outside' of the sql. You can also do something like > this: > > $userid = trim($row['USERID']); > > Then use $userid in your sql. > > 2. Items in arrays must be in quotes. > [/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
