Re: [PHP-DB] Mutiple inserts with one query?

2002-05-31 Thread Patrick Emond
;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-

Re: [PHP-DB] Mutiple inserts with one query?

2002-05-31 Thread Kevin Stone
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

[PHP-DB] Mutiple inserts with one query?

2002-05-31 Thread Leif K-Brooks
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