Ok, now I've done that, I've spent the last couple of hours trying to insert the parsed xml into a database table called teams.
However, I am struggling to do so. I've had a few tries using a number of different methods. http://abeautifulsite.net/notebook/42 http://www.codewalkers.com/c/a/Database-Code/The-opposite-of-mysqlfetchassoc/ and a couple of others. But no luck. The parsed XML looks like this. array(1) { ["Teams"]=> array(1) { ["Team"]=> array(20) { [0]=> array (2) { ["value"]=> string(7) "Arsenal" ["id"]=> string(1) "7" } [1] => array(2) { ["value"]=> string(11) "Aston Villa" ["id"]=> string (1) "9" } [2]=> array(2) { ["value"]=> string(16) "Blackburn Rovers" ["id"]=> string(2) "17" } [3]=> array(2) { ["value"]=> string(16) "Bolton Wanderers" ["id"]=> string(2) "20" } [4]=> array (2) { ["value"]=> string(7) "Chelsea" ["id"]=> string(2) "31" } [5] => array(2) { ["value"]=> string(7) "Everton" ["id"]=> string(2) "53" } [6]=> array(2) { ["value"]=> string(6) "Fulham" ["id"]=> string(2) "60" } [7]=> array(2) { ["value"]=> string(9) "Hull City" ["id"]=> string(2) "72" } [8]=> array(2) { ["value"]=> string (9) "Liverpool" ["id"]=> string(2) "82" } [9]=> array(2) { ["value"] => string(15) "Manchester City" ["id"]=> string(2) "86" } [10]=> array(2) { ["value"]=> string(17) "Manchester United" ["id"]=> string (2) "87" } [11]=> array(2) { ["value"]=> string(13) "Middlesbrough" ["id"]=> string(2) "90" } [12]=> array(2) { ["value"] => string(16) "Newcastle United" ["id"]=> string(2) "95" } [13]=> array(2) { ["value"]=> string(10) "Portsmouth" ["id"]=> string(3) "104" } [14]=> array(2) { ["value"]=> string(10) "Stoke City" ["id"] => string(3) "377" } [15]=> array(2) { ["value"]=> string(10) "Sunderland" ["id"]=> string(3) "127" } [16]=> array(2) { ["value"] => string(17) "Tottenham Hotspur" ["id"]=> string(3) "129" } [17]=> array(2) { ["value"]=> string(20) "West Bromwich Albion" ["id"]=> string(3) "403" } [18]=> array(2) { ["value"]=> string(15) "West Ham United" ["id"]=> string(3) "137" } [19]=> array(2) { ["value"]=> string(14) "Wigan Athletic" ["id"]=> string(3) "138" } } } } Any help on how to do it would be great. Thanks. Sorry for spamming 3 posts... --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to cake-php+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---