visolve.... that's not the function/purpose of the mysql_insert_id... that function still requires you to do multiple hits to the db...
but thanks for the attempt... -----Original Message----- From: Visolve DB Team [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 15, 2006 10:59 AM To: [EMAIL PROTECTED]; mysql@lists.mysql.com Subject: Re: multiple table inserts Hi Bruce U can you mysql_insert_id function to insert values into multiple tables. Please refer to http://www.desilva.biz/mysql/insertid.html for more details. It also illustrates with examples. Thanks Visolve DB Team ----- Original Message ----- From: "bruce" <[EMAIL PROTECTED]> To: <mysql@lists.mysql.com> Sent: Tuesday, August 15, 2006 7:56 AM Subject: multiple table inserts > hi... > > the mysql docs don't seem to allow this.. but i'll ask. > > is there a way to accomplish: > > insert into cat,dog (cat.x,dog.y) values (1,2) > > allowing me to essentially insert items into multiple tables > simultaneously... > > thanks > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
