INSERT help

[Anon]

does anyone know the correct syntax to insert an array into many different rows in a database?
thanks.

[Anon]

more input,

you want each item in the array to be a row in the database?

$db=mysql_connect("host","name","pass");
mysql_select_db("database",$db);
foreach($array as $thisrow){
mysql_query("INSERT INTO tablename ('id','this') values ('','$thisrow')",$db);
}

[Anon]

it works great...thanks!

[Anon]

Faster is to build a unique query like this :

$query = "INSERT INTO tablename ('id','this') values ";

foreach($array as $thisrow){
$query .= "('','$thisrow'),";
}
@(substr($query,0,-1),$db);

Grizzli
http://www.grizzli.org

[Anon]

Your example is longer and not as easy to inderstand, he needed an easy example so he can see what it does.

[Anon]

one problem though...if none of the items are selected, and there's nothing to insert into the database, it gets an error

Warning: Invalid argument supplied for foreach() in /usr/local/apache/htdocs/survey/submit2.php on line 38

any way around this?