Is there a way to insert several rows into a table with one statement? I have this: $sql2 = "INSERT INTO authors (first_name, last_name, ordinal) VALUES ('$first_nameIN', '$last_nameIN', '1')"; $result2 = mysql_query($sql2, $db);
I want to avoid doing another insert like: $sql3 = "INSERT INTO authors (first_name, last_name, ordinal) VALUES ('$first_name2IN', '$last_name2IN', '2')"; $result2 = mysql_query($sql2, $db); -- Phil Jourdan --- p...@ptahhotep.com http://www.ptahhotep.com http://www.chiccantine.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org