Inserting -> MySQL from an array

[Operandi]

Hi

Is there a way of inserting rows into MySQL from an array. I know that I can do this:

foreach ( $array as $val )
{
run an insert query for $val
}

however that creates many queries. Is there are smarter way ie performing only one insert query for all values of the array?

Thanks, in advance

Chris

[jmcneese]

http://pear.php.net/manual/en/core.db.executemultiple.php

[Operandi]

Thanks - that worked perfectly