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?

PHP Code:
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);