Re: [PHP-DB] Copying Data From One Table To Another Table

2008-11-14 Thread Thodoris
Alice Wei wrote: Hi, I am trying to accomplish a task of which I have to copy the data from one table to another. The problem is that whenever I tried to perform the action of copying the data through this method, although the data gets copied, it performs reiterative copying that

Re: [PHP-DB] Copying Data From One Table To Another Table

2008-11-14 Thread chris smith
$result3=mssql_query($query3) or die (The query has failed); snip http://dev.mysql.com/doc/refman/5.0/en/insert-select.html Ah - the OP isn't using mysql, it's ms-sql. -- Postgresql php tutorials http://www.designmagick.com/ -- PHP Database Mailing List (http://www.php.net/) To

Re: [PHP-DB] Copying Data From One Table To Another Table

2008-11-14 Thread Thodoris
$result3=mssql_query($query3) or die (The query has failed); snip http://dev.mysql.com/doc/refman/5.0/en/insert-select.html Ah - the OP isn't using mysql, it's ms-sql. Oups didn't notice that :-) . -- Thodoris

RE: [PHP-DB] Copying Data From One Table To Another Table

2008-11-14 Thread Alice Wei
Hi, Thanks for the trick. I took the query to copy the data outside of the loop, and it is now working! Alice Date: Fri, 14 Nov 2008 14:07:27 +0200 From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] CC: php-db@lists.php.net; [EMAIL PROTECTED] Subject: Re: [PHP-DB] Copying Data From One

[PHP-DB] Copying Data From One Table To Another Table

2008-11-13 Thread Alice Wei
Hi, I am trying to accomplish a task of which I have to copy the data from one table to another. The problem is that whenever I tried to perform the action of copying the data through this method, although the data gets copied, it performs reiterative copying that causes my program and

Re: [PHP-DB] Copying Data From One Table To Another Table

2008-11-13 Thread Chris
Alice Wei wrote: Hi, I am trying to accomplish a task of which I have to copy the data from one table to another. The problem is that whenever I tried to perform the action of copying the data through this method, although the data gets copied, it performs reiterative copying that causes