for $t (0 .. 1000) { $table_name = $tables[$t]; $theValue = $values[$t]; $sql = "INSERT INTO r".$table_name." VALUES ($theValue)"; $std = $dbh->prepare($sql) or die("Could not prepare! At table = $table_name because " . $dbh->errstr); $std->execute() or die("Could not execute!" . $dbh->errstr); }