Posted by Rahul S. Johari on 03/31/05 18:48

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@informed-sources.com
http://www.informed-sources.com


On 3/31/05 10:30 AM, "Jay Blanchard" <jay.blanchard@niicommunications.com>
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

[Back to original message]