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 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...? 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. 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. Link to comment https://forums.phpfreaks.com/topic/152433-solved-trimming/#findComment-801372 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.