hey guys, i had this working before, but when i added another bit, it stopped and now i can't get it to work again :(

//Put data into right tables
 
mysql_query("SELECT* FROM inprogress");
mysql_query("INSERT INTO complete SELECT* FROM inprogress WHERE Status='Y' ");


mysql_query("SELECT* FROM complete");
mysql_query("INSERT INTO inprogress SELECT* FROM complete WHERE Status='N' ");

is this not how you transfer data?

It looks okay. What did you add that made it stop working ?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.