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 --- [email protected]
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/[email protected]
