inserting into mysql db using PEAR within a loop

[Zaggs]

Hi Guys,

I am trying to insert data into a MYSQL database using PEAR, see below for code. The problem I am having is that it only adds one entry and not the 5 that are expected. Any ideas what may be causing this?

foreach($Array as $Value) {
   $this->dbh->query("insert into table (field_1,field_2) values ('Value1','Value2')");
   // Get new user id;
   $NewUserId = mysql_insert_id($this->dbh->connection);
}