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?
You can definitely do this and should do this in the query. Most database applications have a TRIM() function or something like it. You don't mention what database application you're using so I can't be more specific but just check the manual for your database.
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php