insert question

[PJ]

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