[RESOLVED] insert array into table

how do I insert an array into a MYSQL table with just one insert statement??

You want to insert the entire array as a string, or you want to break it up into units?

What if he wanted to break it up in units, like "foreach"...?

SoulAssassin wrote:
What if he wanted to break it up in units, like "foreach"...?

Or [man]implode[/man]

each element would be a different value to insert

well, lets say you have this array.

$ar = array('one', 'two', 'three');

and you had a mysql table (mydata) that looked something like this

id, myValue

you could then do something like this.

$query = "INSERT INTO mydata (myValue) VALUES ('".join("'),('", $ar)."')";

This is what you should end up with

INSERT INTO mydata (myValue) VALUES ('one'),('two'),('three');