Re: Using PHP to move a row of information to another table

You probably want to wrap this in a transaction... $query = "insert into foo select * from bar"; #Execute that. $query = "delete from foo"; #Execute that. Add lots of error-checking and a "begin" and "end" (or "rollback" for an error) -- WARNING richard@zend.com address is an endangered species -- Use ceo@l-i-e.com Wanna help me out? Like Music? Buy a CD: http://l-i-e.com/artists.htm Volunteer a little time: http://chatmusic.com/volunteer.htm ----- Original Message ----- From: Brandon Orther <orther@webintellects.com> Newsgroups: php.general To: PHP User Group <php-general@lists.php.net> Sent: Monday, August 27, 2001 4:33 PM Subject: Using PHP to move a row of information to another table > Hello, > > In MSSQL: > > I want to take one row of information from one table and put it into > another row. Does anyone know of an easy way? Or do I have to go > column by column copying each column into the new table? > > > Thank you, > > -------------------------------------------- > Brandon Orther > WebIntellects Design/Development Manager > brandon@webintellects.com > 800-994-6364 > www.webintellects.com > -------------------------------------------- > >