|
|
Posted by Rahul S. Johari on 03/31/05 21:11
On 3/31/05 12:45 PM, "Joseph Connolly" <jozef1@gmail.com> 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@informed-sources.com
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
>>>
>>>
>>
>>
>>
Navigation:
[Reply to this message]
|