List:General Discussion« Previous MessageNext Message »
From:PJ Date:February 25 2009 1:53am
Subject:insert question
View as plain text  
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 --- pj@stripped
http://www.ptahhotep.com
http://www.chiccantine.com
Thread
insert questionPJ25 Feb
  • Re: insert questionMichael Dykman25 Feb