[RESOLVED] INSERT INTO multiple rows based on $_GET

[luiddog]

I'm trying to insert multiple rows based on a url parameter. So if $_GET['Number'] = 5, I want to insert 5 rows.

 
do {
$insertSQL = "INSERT INTO table (ID, Username) VALUES ('3', 'test')";
  mysql_select_db($database_DB, $DB);
  $Result1 = mysql_query($insertSQL, $DB) or die(mysql_error());
} while ($_GET['Number'] <= ??????); 

Any ideas?

[luiddog]

Got it.

$tid3 = $_GET['Number'];
$i=0;
do {
$i++;
$insertSQL = "INSERT INTO table (ID, Username) VALUES ('3', 'test')";
  mysql_select_db($database_DB, $DB);
  $Result1 = mysql_query($insertSQL, $DB) or die(mysql_error()); 
}  while ($i < $tid3);

[bradgrafelman]

Or, to reduce overhead with multiple queries...

$query = 'INSERT INTO table (ID, Username) VALUES ' . rtrim( str_repeat('(\'3\', \'test\'), ', $tid3), ', ');