[eluser]tonanbarbarian[/eluser]
i have built something before that did what you want
cannot find the code however
what i did was used the insert_string method of the database class to generate all of the queries
then i took the value statement from all but the first query and appeneded them onto the first query
you can then run it as a single statement
code would be something like this
Code:
$insert_sql = $this->db->insert_string('table', array('id'=>1, 'content'=>'foo'));
for ($i=2; $i <= 100; $i++) {
$new_sql = $this->db->insert_string('table', array('id'=>$i, 'content'=>'foo'));
$insert_sql .= ','.substr($new_sql, strpos($new_sql, ' VALUES ')+8);
}
$this->db->simple_query($insert_sql);