On Thursday 21 July 2005 15:02, Jim Moseby typed: > As far as I know, there is no way to insert 20 unique rows of data into a > MySQL table without executing 20 queries. Maybe someone else here does(?). > Perhaps drop a note over on the MySQL list, since this is really more an > SQL question than PHP. Sorry I couldn't help.
Yes, MySQL supports an extended insert syntax of insert into foo (...) values (...), (...), (...). Building that kind of query is left as an excercise for the user. I believe the PEAR DB abstraction layer can accept an array to generate that kind of query. -- My mind not only wanders, it sometimes leaves completely. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
