INserting into MySQL from an array

Hi

Is there a way of inserting rows into MySQL from a PHP 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

Hi,
I think the answer is NO :(
However You can build a single string containing all the subsequent INSERT's delimited with ; and then execute a single mysql_query()...

Alex

I took your advice and created a comma delimited string instead - thanks!