Need some help importing parsed data to mysql

[rbanke]

Nubx,male,Elite Knight,104,Venore,May 19 2005; 09:55:17 CET,Premium Account ,May 10 2005; 01:44:20 CET,Killed at Level 103 by an orc berserker,Feb 21 2005; 05:57:11 CET,Killed at Level 90 by a demon

The above information is being pulled from a website and parsed into what you see. I am wondering how i can now put each piece of information in my table (name,sex,vocation,level,residence,lastlogon,acctstatus,chardeaths)

I have tried a few things but honestly im lost. I need a bit of direction so i dont waste my time learning something only to find its not what i needed to do. Also the chardeath column will need to have the date;reason accept possibly more than one instance per row (both can go in the same field preferably). I can change the ',' to whatever i need if its a problem...i guess i just need a bit of a 'push in the right direction'

(for a game btw)

Thanks
-Rich

[fean0r]

$info ="Nubx,male,Elite Knight,104,Venore,May 19 2005; 09:55:17 CET,Premium Account ,May 10 2005; 01:44:20 CET,Killed at Level 103 by an orc berserker,Feb 21 2005; 05:57:11 CET,Killed at Level 90 by a demon ";
list($name, $sex, $race, $level, $location, $date, $account, $date2, $status, $date3, $status2) = split(',', $info);

Then echo the information you desire.

Hope that helps

Ref:

http://uk.php.net/manual/en/function.split.php

You could also look at:

http://uk.php.net/manual/en/function.preg-split.php