transferring data from one table to another. PHP?

does it matter where you put it (the INSERT call)?

{
//code to select database
}

//Transfer data
mysql_query( "INSERT INTO gancsosa_crystalworks.complete SELECT FROM gancsosa_crystalworks.inprogress");

{
//loop to print out info
}

it doesn't transfer data to complete

Anwered 2010-03-13 08:39:18 by stymiee

If the table with the data is very large it may take MySQL a while to move the data from one table to the other. This means your script will timeout before it gets to finish running. Another possibility is the PHP code before your query is using up a lot of the script execution time and not leaving the query enough time to run before it times out. You should profile your script and your query to see where the bottleneck is.