Read MYSQL and format record

Hello. I have in Mysql lines in table, example: Example select result: $result = "Received sms from: 09688880118; sent date: 3/11/2013 00:12:41 lat:0.035927 long:-51.051464 speed:0.00 T:13/03/09 06:19 bat:100% [login to view URL],-51.051464&z=16" I want PHP read and create variable, example: $number = 09688880118 $latitude = 0.035927 $longitude = -51.051464 $speed = 0.00 $date = 13/03/09 06:19 $bateria = 100% Please see is basic php code. Please create, test and post price. You go use 5min of your site for create this code.