I'm a little confused. Where exactly does php come into play here? What I see, is a manual edit of an xml file thats necessary in order to load what you have. You can certainly open what you have now, fetch the speed element and split it up into individual speed elements by replacing the current speed. For that, I'd suspect you'll need to use the DOM instead of simplexml. I myself have used simplexml like twice, just to answer questions here.
As of PHP 5.5, the MySQL library has been officially deprecated. It is recommended to move to either MySQLi or PDO libraries for your mysql connectivity. See here for help choosing which interface you prefer: http://php.net/manual/en/mysqlinfo.api.choosing.php