SPraus Posted April 3, 2009 Share Posted April 3, 2009 Hey everyone; I need some help, I have the strings 0001.30 0003.00 0030.21 0192.02 1340.00 as prices and i need to trim them in php so that i dont have to change my sql database (so it will order easier) the "trim($string,$char)" dosn't work because there are 0s that I need any ideas (also if you know how to change it so it reads 1.30 in the database but still orders it ^ that way (correctly) please let me know) Thanks In Advance SPraus Quote Link to comment https://forums.phpfreaks.com/topic/152433-solved-trimming/ Share on other sites More sharing options...
Maq Posted April 3, 2009 Share Posted April 3, 2009 Are you using a VARCHAR for this...? Quote Link to comment https://forums.phpfreaks.com/topic/152433-solved-trimming/#findComment-800537 Share on other sites More sharing options...
Yesideez Posted April 3, 2009 Share Posted April 3, 2009 $num=ltrim($txt,'0'); ltrim() will trim on the left only - use rtrim() to trim on the right. Quote Link to comment https://forums.phpfreaks.com/topic/152433-solved-trimming/#findComment-800563 Share on other sites More sharing options...
SPraus Posted April 4, 2009 Author Share Posted April 4, 2009 not using a vchar but the ltrim works, Thanks for quick responce. Quote Link to comment https://forums.phpfreaks.com/topic/152433-solved-trimming/#findComment-801372 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.