there are trim functions in both mysql and php.
both they are called the same...trim, ltrim and rtrim. trim takes off both
sides, and the r and l take the right and left respectively, but yes, this
is possible in the query.
<[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>
10/28/2003 05:11 Subject: [PHP-DB] removing space ?
Please respond to
When I select data from my data base I have spaces on the lead side for
example the data that is stored is " 33.jpg". Spaces included,
exclude the quotes, quotes are example only to show the spaces.
I would like to remove these spaces. Is there a way to do this?
Can it be done in the query?
Any help would be appreciated.
phone: (252) 291-1414 x223
fax : (252) 237-1592
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php