;INSERT INTO your_table VALUES';
for ($i=0; $i<100; $i++)
{
if (!$first) $query .= ', ';
$query .= ' (0,1,2,3)';
$first = false;
}
mysql_query($query); // only one insert statement
Hope that helps,
Patrick Emond
- Original Message -
From: "Leif K-
AIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, May 31, 2002 1:12 PM
Subject: [PHP-DB] Mutiple inserts with one query?
> Is there a way to insert multiple identical rows in one mysql query?
> I'm using a looped query right now, which uses more server load than it
&g
Is there a way to insert multiple identical rows in one mysql query?
I'm using a looped query right now, which uses more server load than it
should... Thanks!
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php