Re: [PHP] copying tables

2002-11-20 Thread Justin French
Hi, I don't have the answer, but when that happens, the first thing I do is dig around in phpMyAdmin(.org)... it's a web based GUI for MySQL, and most of the time, when you do something (like copy a table), it shows you the query used to do it... then you just need to copy it, and integrate it int

Re: [PHP] copying tables

2002-11-20 Thread Jason Wong
On Thursday 21 November 2002 03:34, Edward Peloke wrote: > I apologize, I meant to add a new message, not respond to the copy tables > message. When you want to start a new topic please don't do so by replying to an existing one. Because if you do: - You have

RE: [PHP] copying tables

2002-11-20 Thread Edward Peloke
I apologize, I meant to add a new message, not respond to the copy tables message. -Original Message- From: Edward Peloke [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 20, 2002 2:30 PM To: PHP Subject: RE: [PHP] copying tables Is anyone using php and iframes? I have a php script

RE: [PHP] copying tables

2002-11-20 Thread Edward Peloke
Is anyone using php and iframes? I have a php script "; ?> The script within the frame, auction.php, has buttons that when clicked sends parameters back to this iframe script which calls the auction.php script again with the new parameters. Everything works fine, the only problem is as I cli

Re: [PHP] copying tables

2002-11-20 Thread Chris Shiflett
--- Steve Buehler <[EMAIL PROTECTED]> wrote: > What I am trying to do is to copy a mysql table to a new table name > in a PHP script. An SQL statement similar to this might be what you are looking for: create table tmp_foo as select * from foo I believe this will fail to create any keys, indece

[PHP] copying tables

2002-11-20 Thread Steve Buehler
Using PHP and MySQL. I have looked and can't find the answer to this problem. What I am trying to do is to copy a mysql table to a new table name in a PHP script. The reason for this is to keep the original table the way it is and editing the copy. Now, I know that I can go through a loop rea