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
$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
$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
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
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
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