Insert Array?

[Anon]

Hi there,
i have a string that looks like the following;

file1.ext:1024 file2.ext:2053 file3.ext:10273

i need to find a way of inputting each different bit as a seperate row in a table, for example:

filename Size

file1.ext 1024
file2.ext 2053

file3.ext 10273

Maybe i need some sort of array or while loop? Im not sure so any suggestions or scriptlets would be greatly appreciated.

Jonathan

[Anon]

$stringArray = explode(" ",$string);

explode($separator,$string) returns an array split by the supplied separator.

[Anon]

assuming mySQL:

<?
$string = 'file1.ext:1024 file2.ext:2053 file3.ext:10273';
$array = explode (' ', $string);
foreach ($array as $value)
{
$substring = explode (':', $value);
mysql_query ("INSERT INTO tablename SET filename = '$substring[0]', size = '$substring[1]'");
}
?>

[Anon]

cheers guys. works amazing.